Forum Discussion

JML's avatar
JML
New Member
9 years ago
Solved

Repeating reports from different data sets

Hi all,   I'm using PowerBI Desktop to create reports for a software platform that we sell. Reports are based on ~10 csv files that we export from the platform. I'm pretty new to PowerBI and lookin...
Need Help
Tips and Tricks
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    JML

     

    For your requirement, you can create Query Parameter to set a dynamic data source. Please refer to sample below:

     

     

     

    1. Create a File Name parameter.

     

     

    2. Modify the Power Query in Advanced Editor.

     

     

    3. Then you can get a dynamic dataset based on selection in Query Paramete (you need to Apply Changes after select):

     

     

     

     

     

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

JML

 

For your requirement, you can create Query Parameter to set a dynamic data source. Please refer to sample below:

 

 

 

1. Create a File Name parameter.

 

 

2. Modify the Power Query in Advanced Editor.

 

 

3. Then you can get a dynamic dataset based on selection in Query Paramete (you need to Apply Changes after select):

 

 

 

 

 

Regards,

 

JML's avatar
JML
New Member
9 years ago

Thanks for the replies - that solution works - just took a while to work through for a novice. Thanks!