Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

How to organize dataflows selection in Power Query by parameter

Hello everyone

Kindly asking for an idea/direction or maybe there is a solution exists already

I've got next situation: 
- report template
- a list of clients, who uses this report, it's the same for all of them
- for each client there is his own Dataflow as a source (with a number of queries in PBI service)

How to find a solution (I see it's a parameter), so we could choose a client in PBIX Power Query area (somewhere, somehow), and it would dinamically change a link in to chosen client's Dataflow in queries in PBIX? And then just Apply and Upload changes.

Please see a schema attached.

Any help will be highly appreciated
Thanks a lot



Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors