Forum Discussion
Global Workspace Parameters?
Hi,
I know that we can use parameters to change the datasource settings. i.e.- Have the desktop report pulling from a dev database and then have the report parameter set up in the prod workspace to pull from the prod database. So that as soon as the report is uploaded, the dataset will change from dev to prod.
The question I've been asked by my data engineering team is, is there a way to set a global parameter in a workspace? So if you want to change a parameter, you don't have to do it one at a time to each dataset, you can just make one change and it will change that parameter for every report that has that parameter? Hopefully that makes sense...
3 Replies
Hi kewaynes ,
Currently, power bi does not support global parameters. You can vote for these similar ideas.
Global parameters at workspace level or Organization Level
Global Parameters at the Power BI Workspace App Level
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
There is still no built-in support for global parameters, but you can work you way around this using an environment file. I have written a step-by-step tutorial on how to do this here: https://medium.com/p/16383679eb06
Your blog has a good start. On how to do this using config files.
I'm using the same for metadata of my sources to easily add tables or files to extract and already have the key information stored.
The issues is maintanance following the Microsoft best practises, you have 1 lakehouse per bronze, silver and gold. Futhermore you will have test, acc and prod environments and dev environments per engineer?
And handling 10+ of those files is simply a pain. Specially when simple parameters should be able to fix it.
