cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daniel_Altevogt
Advocate II
Advocate II

Power BI Desktop Client Registry Settings

Dear Community,

I'd like to share some information with you, about Registry Settings I've found to manage Power BI Desktop Cloud Client (v. 2.96.901.0) so far.  I'm currently looking for registry hacks for a central managed Power BI Desktop Client setup, so I thought some settings may be for interest for someone else as well.

Please keep in mind, that changing registry may corrupt your system!

 

1)

Daniel_Altevogt_0-1629879832452.png

Key: HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Microsoft Power BI Desktop

valueName: ShowLeadGenDialog

or

Key: HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft Power BI Desktop

valueName: ShowLeadGenDialog

Disable: REG_DWORD "0"

 

2)

Daniel_Altevogt_1-1629879927202.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: DisableUpdateNotification.
  3. Set the value of that new entry to 0, 1.
  4. Restart your computer for the change to take effect.

3)

Daniel_Altevogt_2-1629879979224.png

  1. In the Registry Editor, navigate to the HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: EnableCustomerExperienceProgram
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

4)

Daniel_Altevogt_3-1629880033848.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: GlobalTypeDetectionSetting
  3. Set the value of that new entry to 0, 1, 2
  4. Restart your computer for the change to take effect.

 

5)

Daniel_Altevogt_4-1629880066328.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: GlobalPrivacyLevel
  3. Set the value of that new entry to 0, 1, 2
  4. Restart your computer for the change to take effect.

6)

Daniel_Altevogt_5-1629880098759.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: DisableCertificateRevocationCheck
  3. Set the value of that new entry to 0, 1, 2
  4. Restart your computer for the change to take effect.

7)

Daniel_Altevogt_6-1629880128819.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: DisableNativeDbQueryPrompt
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

😎

Daniel_Altevogt_7-1629880168383.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\ SOFTWARE\Policies\Microsoft\Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: EnableArcGISMaps
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

9)

Einstellung “Default system credentials for web proxy“

Web requests issued by Power BI Desktop do not use web proxy credentials. In networks that use a proxy server, Power BI Desktop may not be able to successfully make web requests.

System or network administrators can allow the use of default system credentials for web proxy authentication. Administrators can create a registry entry called UseDefaultCredentialsForProxy, and set the value to one (1) to enable the use of default system credentials for web proxy authentication.

 

32-Bits: [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft Power BI Desktop]

64-Bits: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop]

 

  1. Create a new REG_DWORD entry in the key with the following name: UseDefaultCredentialsForProxy
  2. Set the value of that new entry to 0, 1
  3. Restart your computer for the change to take effect.

10)

Daniel_Altevogt_8-1629880231028.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\ SOFTWARE\Policies\Microsoft\Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: EnableExternalTools
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

 

11)

Daniel_Altevogt_9-1629880260678.png

  1. In the Registry Editor, navigate to the HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: TracingEnabled
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

 

12)

Daniel_Altevogt_10-1629880296503.png

Number of evaluation containers

You can control the number of evaluation containers and thereby influence the level of parallelization for query execution in PowerQuery by setting the DWORD registry value ForegroundEvaluationContainerCount. Set the DWORD registry value ForegroundEvaluationContainerCount in the Power BI Desktop registry key. By default, Power BI Desktop creates a maximum of 20 evaluation containers. The minimum value is 1 and the maximum value is equivalent to the number of CPU cores on the machine.

Available memory per evaluation container

You can control the available memory per evaluation container by setting the DWORD registry value MaxEvaluationWorkingSetInMB. This setting configures the available memory per evaluation container in MB and by default Power BI has a maximum memory allocation per evaluation container of 432 MB. The minimum value is 1 (recommended a minimum of 256) and the theoretical (but not recommended) maximum value is equal to a 100% of the RAM on the machine divided by the number of evaluation containers (set by ForegroundEvaluationContainerCount). As a best practice we recommend never setting this value higher than 90% of the RAM on the machine.

32-Bits: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft Power BI Desktop

64-Bits: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop

 

13)

Daniel_Altevogt_0-1629970604060.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: SuportMultiLanguage
  3. Set the value of that new entry to 0,1
  4. Restart your computer for the change to take effect

Activates / Deactivates multilanguage support settings for PBI Desktop Client users

Languges is set to "DefaultUICulture" when it's set to "0".

 

14)

Daniel_Altevogt_1-1629970747380.png

  1. In the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_SZ entry in the key with the following name: UICulture
  3. Set the value of that new entry to de-DE, en-US, da-DK, etc.
  4. Restart your computer for the change to take effect.

Default language for PBI Desktop Client and will be used for Users Defaults Regional Settings

 

15)

Daniel_Altevogt_2-1629970932834.png

  1. In the Registry Editor, navigate to the HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_SZ entry in the key with the following name: UICulture
  3. Set the value of that new entry to de-DE, en-US, da-DK, etc.
  4. Restart your computer for the change to take effect.

(Delete Entry to reset to "Use Windows Default Display Language" again)

 

16)

Daniel_Altevogt_3-1629971000969.png

  1. In the Registry Editor, navigate to the HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_SZ entry in the key with the following name: ModelCulture
  3. Set the value of that new entry to de-DE, en-US, da-DK, etc.
  4. Restart your computer for the change to take effect.

(Delete Entry to reset to "Use Application Lanaguage" again)

 

17)

Daniel_Altevogt_4-1629971129813.png

  1. In the Registry Editor, navigate to the HKEY_CURRENT_USER\Software\Microsoft\Microsoft Power BI Desktop key.
  2. Create a new REG_DWORD entry in the key with the following name: BypassGeocodingCache
  3. Set the value of that new entry to 0, 1
  4. Restart your computer for the change to take effect.

 

I hope that Microsoft will implement some more registry keys with next Client Versions, some settting are still only availiable within user.zip.

 

Also some of above registry settings may also work with SSRS Desktop Client as well, but please keep in mind, that SSRS client uses another registry path:

Daniel_Altevogt_11-1629880813287.png

I haven't tested setttings with SSRS client jet.

 

Please keep in mind, that changing registry may corrupt your system! Please test before doing in production!

 

If you've found additional settings as well, please feel free to add information as comment.

 

Many thanks & best regards

Daniel

4 REPLIES 4
IMett
Helper II
Helper II

Dear @Daniel_Altevogt , thank you for these interesting insights.

Do you (or someone else) maybe know if it is possible to change the default for data export options via registry or user.zip?

 

IMett_0-1631808387358.png

 

Hello @IMett ,

 

unfortunately your setting is a Report setting within PBI Desktop, therefore I can't imagine that you can manage it as a global setting. These settings are some kind of stored within PBIX file when you save it.

If you want to archive some kind of default layout you might take a look to Power BI Desktop template files "PBIT" including your settings and CI.

If you want this file to be default, you can setup Desktop Client to open it by default with command like: PBIDesktop.exe "Path to PBIT file\Template_01.pbit"

 

Best regards

Daniel

Hi @Daniel_Altevogt , thank you very much for your reply.

We are already using .pbit files, but I was not aware that it is possible to open them by default. This sounds like an excellent idea and might be sufficient to fulfill our requirements.

 

Regards, Ilja

Icey
Community Support
Community Support

Hi @Daniel_Altevogt ,

 

Thanks for your sharing! 

 

And it is suggested to post your idea on Ideas (powerbi.com)


I hope that Microsoft will implement some more registry keys with next Client Versions, some settting are still only availiable within user.zip.

 


It is a place for customers to provide feedback about Power BI.


What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!