Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Parameterization in Power BI

We  are working on parameterizing the connections, currently what we did is created parameters in report to pass database connections. But as we have 18 different datasets/reports, we have to create parameters in each dataset/report. So, we are planning to create one global parameter so that if we can change connection at one place, it will reflect in all the 18 datasets/reports. 

In addition to that, we are expecting report/dataset deployment between multiple environment (Dev/Test/Prod). If we create a global parameter, it will give us flexibility to change between environments. so that we can point our dataset/reports to any environment we want.

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for sharing information but this is  normal parameterization approch that we are using. here we need to change the parameter value in each and every report in power BI desktop/web service.

      we are looking for more dynamic parameterization where we can chnage the value of the parameter at one place  and it should be used by all the reports on the workplace.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Unfortunately, power bi does not provide this feature now, so you can only change the parameters one by one.
    Workaround:

    You can consider using dataflows to merge multiple data sources into a single dataset. And by importing a parameter table, you can change the parameters uniformly. I mean get parameters from the table rather than one by one.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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