Forum Discussion
How to configure Power BI Desktop options?
3. On the DirectQuery tab, enable the Allow unrestricted measures in DirectQuery mode setting. This enables additional DAX functions to be used in metrics against DirectQuery data models that are necessary to meet many common requirements.
Although all DAX functions are supported for DirectQuery models, certain functions are not optimized for DirectQuery; they may not generate an efficient SQL query and may require local, single-threaded resources to execute.
Super UserGLOBAL options are applied to all Power BI Desktop files created or accessed by the user, while CURRENT FILE options must be defined for each Power BI Desktop file. The following steps are recommended for GLOBAL options.
1. On the Data Load tab, confirm that the currently used data cache is below the Maximum allowed (MB) setting. If it is near the limit and local disk space is available, increase the value of the Maximum allowed (MB). Do not clear the
cache unless local disk space is unavailable as this will require additional, often unnecessary, queries to be executed at design time.