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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.