Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'd like to ask if somebody knows a registry key for disabling the time intelligence for new files. Or is there another way how to distribute Power BI Desktop with the disabled time intelligence?
Thank you very much for every hint.
Best regards,
Nolock
Hi @Nolock,
AFAIK, this option is a global setting option, it will affect the default power bi desktop options. (notice: this option does not change the table Date fields that already analytic by auto date/time feature, you need to rebuild these tables)
You can take at the following document to know more about this:
Apply auto date/time in Power BI Desktop
Regards,
Xiaoxin Sheng
Hello @v-shex-msft,
thank you for your answer, but it didn't take me further.
The problem is that the time intelligence is a big mess. You don't want to have an extra date dimension table written in DAX for every date/datetime column in your model. AFAIK it is not compressed by the Vertipaq engine and it consumes a lot of memory. You also can't add new levels to the hierarchy or remove the existing ones.
I always recommend using a date dimension written in M, like this one for example: https://community.powerbi.com/t5/Community-Blog/Date-Dimension-with-Holidays-in-PowerQuery/ba-p/7459...
I'm going to distribute PBI Desktop to hundreds of users and it is not possible to explain everybody that they should deactivate this feature. Therefore I'm searching for an option how to disable the setting globally in advanced.
Hi @Nolock,
In fact, I think this is a compromise chose to balance the performance and practicality.
If you enable this feature, it will generate corresponding personal date dimensions to add support of time intelligence functions and improve the performance of chart field aggregations.
The performance issue will appear when you are processing with huge amount of records or complex report structure.
So I'd think the major point is how to improve this feature instead of removing it, right?
If this is a case, I'd like to suggest you submit an idea to improve this feature to reuse these hidden date dimension fields instead of generating multiple fields, it should reduce the cost of using this feature.
Regards,
Xiaoxin Sheng
@Nolock ,
Good day,
If you uncheck in Global area.. isn't it disable for all new files,...? i believe it will disable...
Thanks & Regards,
Mohammed Adnan
https://www.youtube.com/taik18
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |