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

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Power BI Dev Camp Session 32

Ted's Dev Camp - March 30, 2023

In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.

Top Solution Authors