Forum Discussion

garrek99's avatar
garrek99
Helper 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

garrek99's avatar
garrek99
Helper I
10 years ago

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.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

garrek99

 

I'm also doing the Import mode. What about the solution provided by MattAllington?

 

Best Regards,

Herbert

  • garrek99's avatar
    garrek99
    Helper I
    10 years ago

    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.