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
Icon for Community Champion rankCommunity 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

 

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Vvelarde

 

Excellent tip.

 

The screen shots are a bit blurred and hazy. 

 

Can you just paste the pop-ups alone and not the entire power bi page.  like 

 

 

Appreciate if you can send the clear enalarged portions.

Thanks again

 

Cheers

 

 

 

 

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    10 years ago

    I upload the new screenshot. Now i have more time to edit the images.