Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
D3K
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)


Question:
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
2023-02-03_10-02-57.png

 

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.