Forum Discussion

garrek99's avatar
garrek99
Icon for Helper I rankHelper I
10 years ago
Solved

Removing data from .pbix file?

Does anyone know how to dump the data from a report file (while leaving everything else intact)?   We are backing up our report files daily and each file is like 300+MB.   Is there a way of dumpi...
Need Help
  • DarranShepherd's avatar
    DarranShepherd
    9 years ago

    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

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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,