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
garrek99 there is a way to dump data but that won't actually reduce your pbix file size. within query editor you have option of executing R script on your tables. so as a last step you can have R script that outputs your data into a csv but that will just take a dump out of your data. if you're interested in doing that then R script syntax will be,
The thing is that our data is on the cloud and we see no point in having a copy of it in a csv file.
R is something we'll explore soon when we start playing with involved analytics.
TY
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'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
