Forum Discussion

MojoGene's avatar
MojoGene
Post Patron
6 years ago
Solved

Use PBI Template with parameter for different database??

Not sure if this is possbile with parameters and PBI templates.   Assume that we have Company A and Company B both of which are using a sales database with identical structure (same tables, fields,...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, MojoGene 

     

    I'd like to suggest you create three parameters as below.

     

     

     

     

    Then you may click 'Advanced Editor' and parameterize the data source. I use SQL Server to test.

     

    Then you need to save it as a template file(pbit file).

     

    When you open the pbit file, you may input the corresponding parameter to connect to the specific table.

     

    For further information, I'd like to suggest you refer the following links.

    Create report templates for Power BI Desktop 

    Deep Dive into Query Parameters and Power BI Templates 

    Power BI Desktop Query Parameters 

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, MojoGene 

 

I'd like to suggest you create three parameters as below.

 

 

 

 

Then you may click 'Advanced Editor' and parameterize the data source. I use SQL Server to test.

 

Then you need to save it as a template file(pbit file).

 

When you open the pbit file, you may input the corresponding parameter to connect to the specific table.

 

For further information, I'd like to suggest you refer the following links.

Create report templates for Power BI Desktop 

Deep Dive into Query Parameters and Power BI Templates 

Power BI Desktop Query Parameters 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.