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

     

     

brissae's avatar
brissae
Frequent Visitor
10 years ago

Vvelarde How can it do that? I mean do I have to upload the file and then hit refresh?

I am starting with Power Bi that's why Im a little bit lost.