Forum Discussion
Removing data from .pbix file?
I've just been trying this myself and observed different behaviour depending on how you save the .pbit
File > Save As > .pbit = File size roughly equal to the original report
File > Export > Power BI Template = Significantly reduced file size
Just to confirm, which file size did you observe? My template file (.pbit) will be much smaller than the .pbix file.
A 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.). In other words, a Power BI Report template includes pretty much everything that a Report file includes, with the exception of the data itself.
Best Regards,
Herbert
I even tried creating a .pbit from scratch and as soon as I save it the file size jumps.
Are you doing the DirectQuery method or Import method? Could that be the difference?
DirectQuery is not an option for us because it limits the capabilities too much.
I'm also doing the Import mode. What about the solution provided by MattAllington?
Best Regards,
Herbert
Matt's option is very involved and with a small team of people with different tech skills will be hard to implement.
We have to use Import method so are still looking for a solution. Thank you.