Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Wresen
Post Patron
Post Patron

Save Template with everything except dataset as a "Shell"

Hi.

I have a report with 3 sheets and alot of graphs and bookmarks.
Is it possible to save down the "shell" of all this so i can make a new report where i just import the dataset and this template (Shell).

 

(I will uppload this report to another app and would like just have 1 app that i reload with new data)

 

/Thanks so much

2 ACCEPTED SOLUTIONS

Hi

I found a sulotion (Not sure if this what you said  @amitchandak )

I take a copy of the report, i delete everything under the fields (tables , measure and such)
When alla the data is gone i have the "Shell" and the option to add "Power BI datasets" under the Home tab works.

 

if not all the data is delete you will get and error message when trying to add a "Power Bi datasets"

View solution in original post

@Wresen Correct. A PBIT is for saving a file without the data in it, which is why it is small. That way, you can use it for version control without exposing sensitive data or storing 270MB each time. Also, they are handy if you want to send it to someone and they can point it to their data that mirrors your format/model. Think 20 people with Systems Center Configuration Manager installed. You can create reports, they point it to their instance of SCCM and they get the reports with their data versus anyone else's SCCM data. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
amitchandak
Super User
Super User

@Wresen , the template should save it without Data ? I think so.

And Pbix you want to save then jsut attached empty sheets.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks @Greg_Deckler  and @amitchandak 

 

I might have not explained good what i wanted.

 

@amitchandak  Yes i just want the template without data.

@Greg_Deckler  i tried what you wrote but when i do that i also data , i just want the report without data so i can import the dataset. (I have alot of options when i try this , sample file , transform sample file and so on , and from what i can see all contains the data)

/Thanks

Hi

I found a sulotion (Not sure if this what you said  @amitchandak )

I take a copy of the report, i delete everything under the fields (tables , measure and such)
When alla the data is gone i have the "Shell" and the option to add "Power BI datasets" under the Home tab works.

 

if not all the data is delete you will get and error message when trying to add a "Power Bi datasets"

@Wresen - A PBIT should be the Power BI report without the data. Sorry, not understanding what you are seeing.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler 

 

I might not understand that then how the Pbit works. I make a Pbit of my report like you mention above (it becoms 3 Meg in Size instead of 270meg)

I Import the Pbit in a new report , But before it get loaded a window pop up and i have to choose between Load or Edit in a drop box and i have another dropbox with Parameters (all the tabels and such) and options for Sample File , Transformed File or Transformd Sample file. 
If i choose Load and Sample File as the dedaut it becomes a normal report with all the data (when saved its size its around 270 meg again)

 

/Thanks

@Wresen Correct. A PBIT is for saving a file without the data in it, which is why it is small. That way, you can use it for version control without exposing sensitive data or storing 270MB each time. Also, they are handy if you want to send it to someone and they can point it to their data that mirrors your format/model. Think 20 people with Systems Center Configuration Manager installed. You can create reports, they point it to their instance of SCCM and they get the reports with their data versus anyone else's SCCM data. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

@Wresen - Yes, save it as a template (PBIT) file. File | Save As, select PBIT from the drop down:

Greg_Deckler_0-1599541487017.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.