Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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)
3)
4)
5)
6)
7)
😎
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]
10)
11)
12)
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.
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)
Activates / Deactivates multilanguage support settings for PBI Desktop Client users
Languges is set to "DefaultUICulture" when it's set to "0".
14)
Default language for PBI Desktop Client and will be used for Users Defaults Regional Settings
15)
(Delete Entry to reset to "Use Windows Default Display Language" again)
16)
(Delete Entry to reset to "Use Application Lanaguage" again)
17)
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:
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
Are there some changes in the regestry from microsoft?
The regestry key do not work in my envirement.
Do you have an idear @Anonymous ?
Looks like any of these using HKEY_LOCAL_MACHINE\ SOFTWARE\Policies\Microsoft\Power BI Desktop are no longer working since that folder isn't available in the registry anymore. Is anyone else having this problem?
Dear @Anonymous , 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?
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 @Anonymous , 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
Hi @Anonymous ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |