Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey guys,
I am currently working on a project with my company using PowerBI and am approaching my first roadblock. I have designed a format for the report that I want to use and then extract via a PDF. However, the problem is I need to use this same format for multiple countries that we have the data for. The data in every excel file is the same format, and I just want to be able to keep the format uniform, while being able to easily just upload the new excel file into it. How do I go about doing this?
Solved! Go to Solution.
Hi @Anonymous ,
From your description, you could refer to using template in power bi:
https://www.powerbitutorial.org/tutorials/power-bi-templates/
You could use it to store your default format and apply it for different data.
Regards,
Daniel He
Hi @Anonymous ,
From your description, you could refer to using template in power bi:
https://www.powerbitutorial.org/tutorials/power-bi-templates/
You could use it to store your default format and apply it for different data.
Regards,
Daniel He
Hey Daniel @v-danhe-msft
I think this template route is what I need, however, when I saved my file as a template, I then uploaded it and it still contained the data from my previous excel file. How do I get it to be able to switch datasets but maintain the exact template?
Hi @Anonymous ,
It is decided by how you connect data, you could refer to below blog about sql server:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Daniel He
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
51 | |
51 | |
26 | |
25 | |
20 |