Which alternative option must be enabled to stop Power BI from auto-generating hidden date tables?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Master the Microsoft Power BI Data Analyst Certification (PL-300) with our quiz. Test your knowledge with flashcards and multiple choice questions with hints and detailed explanations. Prepare effectively for your certification exam!

The option to stop Power BI from auto-generating hidden date tables is to disable the feature found in the global options that controls the creation of these tables. This is achieved by navigating to the settings or global options and turning off the Auto Date/Time feature for new files. When this setting is enabled, Power BI automatically creates a hidden date table for date fields it detects in your data model.

Choosing the option to "Enable Mark as date table for each Date table" does not address the issue of stopping the automatic generation of hidden date tables. In fact, marking a table as a date table is a process related to ensuring that Power BI recognizes and uses a specified table for date operations correctly, which is different from the generation of hidden date tables.

To effectively manage date tables in your Power BI reports and models, it's vital to adjust the settings related to auto date/time creation, ensuring that the generation of these hidden tables aligns with your design preferences and data modeling practices.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy