Forum Discussion
Solved
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.
Sahir_Maharaj
Super User
Super UserOn the privacy tab, configure the privacy levels for all data sources and enable the option to Always combine data according to your Privacy Level settings for each source.