Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am wondering on the best method to use on the following issue :
I am wondering what would be the best way to implement that. I have considered the following options :
I would hope someone could point me the right direction
thanks
g
Solved! Go to Solution.
Hi @Anonymous,
You can create parameters in your Desktop file to define which excel file(contains specific column name and column title) to connect to, then create reports in the Power BI Desktop file.
And in order for other users to use the model in your Power BI Desktop file, you can create a Power BI Report Template(PBIT file) , 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 users 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 this blog: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Thanks,
Lydia Zhang
Hi @Anonymous,
You can create parameters in your Desktop file to define which excel file(contains specific column name and column title) to connect to, then create reports in the Power BI Desktop file.
And in order for other users to use the model in your Power BI Desktop file, you can create a Power BI Report Template(PBIT file) , 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 users 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 this blog: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |