How to configure Power BI Desktop options?

[Sahir_Maharaj]

Please note that this is the settings configurations that I have applied to my PBi Desktop instance. Feel free to adapt as required 🙂

Hope this helps!

[Sahir_Maharaj]

6. On the Data Load tab for the CURRENT FILE, disable the automatic detection of column types and relationships. These model design decisions should be implemented explicitly by the Power BI developer with knowledge of the
source data.

[Sahir_Maharaj]

5. Enable Preview features for evaluation purposes

[Sahir_Maharaj]

On 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.

[Sahir_Maharaj]

4. On the Security tab, select the option to require user approval for new native database queries. Native queries are the user-specified SQLstatements passed to data sources as opposed to the queries Power BI generates internally.

[Sahir_Maharaj · Accepted solution]

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.

[gb12]

Hallo @Sahir_Maharaj ,

Thanks for your response.

Can you kindly provide the link to resources that you might have accessed to formulate these valuable responses?

Hope you don't mind me asking - I am a newbie wanting to learn more on setting up configs myself, esp in on on-premises gateways, etc. 

Your assistance is appreciated 🙂

[Sahir_Maharaj]

2. On the Query Editor tab, display both the query settings pane and the formula bar. This will allow for greater visibility to the structure and specific M functions utilized by individual queries.

[Sahir_Maharaj]

GLOBAL 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.

[Sahir_Maharaj]

Developers of Power BI content should become familiar with the settings available in Power BI options and data source settings as these configurations determine available functionality, user interface options, default behaviors, performance, and the security of the data being accessed.