Forum Discussion

brissae's avatar
brissae
Frequent Visitor
10 years ago
Solved

How to create a template with a different data source every time?

Hello all!   I have a report that needs to be built every time we get a new excel file with new information, but this report is executed for many people in our organization and we need a tool that ...
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Create your PBI File and Go to Query Editor (Edit Query) and go to Manage Parameters:

     

    Create the parameters for you Datasource like this sample:

     

     

     

     

    Next Step: Go to Source: And Select Parameter

     

     

     

     

    Next Step: Export like Template Power BI & Close

     

     

     

     

    Finally Open the Template and Enter the datasource

     

     

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

Create your PBI File and Go to Query Editor (Edit Query) and go to Manage Parameters:

 

Create the parameters for you Datasource like this sample:

 

 

 

 

Next Step: Go to Source: And Select Parameter

 

 

 

 

Next Step: Export like Template Power BI & Close

 

 

 

 

Finally Open the Template and Enter the datasource

 

 

kawsarhamid's avatar
kawsarhamid
New Member
8 years ago

Vvelarde I tried it. It works fine. 

 

I published the report on PowerBI web and created an App. But when other user in my Organization try to get it, the user does not prompt user to put value for parameter!

 

How can I do that?