This is fantastic and very clearly defined. Just a note to guys having trouble getting the relationship between the date fields to work, make sure the date format is the same across tables - This is especially true when trying to compare timestamp with short dates
Thank you! This video helped me resolve an issue I had with a source I was trying to remove from a Report. It was a direct query to a Power BI dataset (which had local date tables). After removal of the source, the metadata refresh would not complete and on refresh, it would complain that there are missing localDate tables. I tried the toggle of the Auto date time option, but that did not work as the localdate table was in the other DQ PowerBI dataset not in my part of the model. Using Dax Studio I could click on the localdate tables (before removing the data source) and identify where they are referenced. I then deleted those tables individually, before removing the source altogether.
Hi Barend, just in case you have some tip...I'm running into similar kind of issue, I turned off local date table, but the date tables do not go away. I haven't found any way to delete them...how did you do that? they are not in the model...we see them in Tabular Editor and Dax Studio, but nowhere it's allowing to delete them. Thanks.
Hello, my pbix file was over 955mb I found out using dax studio that there were lots of these date local tables with a huge size, y uncheck this option and my file size went down to 9.7mb what will be my major impact on the report ? This is a dashboard that I did not develop but I have the task to make it the file faster and lower their size, the first appoach was to remove columns and tables not needed but it was almost same size and I was not able to refresh the file with power bi desktop i was getting an error saying i dont have enought memory after doing this everything worked. What is your advice is this a good way to go about this issue ?
Thanks Alberto. After following this advice, I am now stuck thinking if I should rework my entire series of workings as it has broken all my codes written. Can you provide a short tutorial on how to fix this?
If you have a large number of measure to modify, you should take a look at Tabular Editor, which has the ability to create scripts to modify the existing measures (you can do some search/replace across all the measures, but it requires a few lines of script code - however, there is a lot of documentation and many examples). tabulareditor.com/
Isn’t the best practice is to get the single dimension date table that contains hierarchy into the model , build the relation around the table and we can use the date to slice the date how we like ? It’s also good practice not to enable the auto date-time as the local date table can use lot of memory, as they can be compressed better using the vertipaq engine
Yes, but it's also the purpose of the video! BTW the auto date-time creates a table compressed by VertiPaq, it's just that it creates many of them and that is usually not ideal (and expensive).
This is fantastic and very clearly defined. Just a note to guys having trouble getting the relationship between the date fields to work, make sure the date format is the same across tables - This is especially true when trying to compare timestamp with short dates
Thank you! This video helped me resolve an issue I had with a source I was trying to remove from a Report. It was a direct query to a Power BI dataset (which had local date tables). After removal of the source, the metadata refresh would not complete and on refresh, it would complain that there are missing localDate tables. I tried the toggle of the Auto date time option, but that did not work as the localdate table was in the other DQ PowerBI dataset not in my part of the model. Using Dax Studio I could click on the localdate tables (before removing the data source) and identify where they are referenced. I then deleted those tables individually, before removing the source altogether.
Hi Barend, just in case you have some tip...I'm running into similar kind of issue, I turned off local date table, but the date tables do not go away. I haven't found any way to delete them...how did you do that? they are not in the model...we see them in Tabular Editor and Dax Studio, but nowhere it's allowing to delete them. Thanks.
Thanks for the video!
Thanks very much!
My problem is when I uncheck and click OK, it stayed stuck and never finished?
Excellent video!
Very useful, thank you!
Thanks a lot 😀
Hello, my pbix file was over 955mb I found out using dax studio that there were lots of these date local tables with a huge size, y uncheck this option and my file size went down to 9.7mb what will be my major impact on the report ?
This is a dashboard that I did not develop but I have the task to make it the file faster and lower their size, the first appoach was to remove columns and tables not needed but it was almost same size and I was not able to refresh the file with power bi desktop i was getting an error saying i dont have enought memory after doing this everything worked.
What is your advice is this a good way to go about this issue ?
Thank you so much @Alberto
Thanks Alberto. After following this advice, I am now stuck thinking if I should rework my entire series of workings as it has broken all my codes written. Can you provide a short tutorial on how to fix this?
If you have a large number of measure to modify, you should take a look at Tabular Editor, which has the ability to create scripts to modify the existing measures (you can do some search/replace across all the measures, but it requires a few lines of script code - however, there is a lot of documentation and many examples).
tabulareditor.com/
Thank you
Isn’t the best practice is to get the single dimension date table that contains hierarchy into the model , build the relation around the table and we can use the date to slice the date how we like ? It’s also good practice not to enable the auto date-time as the local date table can use lot of memory, as they can be compressed better using the vertipaq engine
Yes, but it's also the purpose of the video!
BTW the auto date-time creates a table compressed by VertiPaq, it's just that it creates many of them and that is usually not ideal (and expensive).
Thanks
It removesthe date hierarchy, should we make it manually?
Yes, and you are free to create any hierarchy, too.