Forum Discussion
PowerBI Templates : Data Source Excel Files are different
Hi,
I need to know how can I create a Power BI Template and connect it to a different data source.
Excel file are the same, expect the input values for the tables changes for each user. Excel file Tables, Relationships are same.
Simple to say, we are trying to Connect an Excel Template to Power BI Template.
regards,
Singaravelu S
sing_ideas,
In Power BI Desktop, you can create a Power BI report template with Excel data source parameter. The Power BI Report Template contains the definition of the Report (pages, visuals, etc.), Data Model definition (schema, relationships, measures, etc.) and Queries definition (collection of queries, including Query Parameters, etc.). Other customers can instantiate your template by double-clicking on the PBIT file, or by using the “File –> Import –> Power BI Template” path.
For more details, please review the blog below and similar thread.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every-time/td-p/50969
Regards,
1 Reply
sing_ideas,
In Power BI Desktop, you can create a Power BI report template with Excel data source parameter. The Power BI Report Template contains the definition of the Report (pages, visuals, etc.), Data Model definition (schema, relationships, measures, etc.) and Queries definition (collection of queries, including Query Parameters, etc.). Other customers can instantiate your template by double-clicking on the PBIT file, or by using the “File –> Import –> Power BI Template” path.
For more details, please review the blog below and similar thread.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every-time/td-p/50969
Regards,