on 02 Nov 2016 16:11:54
I work as a BI consultant at a Microsoft CSP. I have built a model using sales data from Dynamics NAV which we will offer to our customers.
I built the model and made a few report pages in the file and at this point the file size was close to 3MB. I then gave the file to a colleague that should finish the report and make them look nice. After working with the reports the file suddenly increases in size to a little more than 65MB (more than 22 times the original size).
No changes have been made the data in the file only changes to the reports.
I have tried to remove all the report pages from the file but this does nothing to the size it is still 65MB.
- Comments (3)
RE: Sudden increase in .pbix file size
Did you turn on the auto Date Table feature ?
In Options > Data Load >Time Intelligence Auto Date / Time ?
If you have a lot of date fields it dramatically increase the file size.
RE: Sudden increase in .pbix file size
I have the same problem!!! This is becoming a big issue and I suggest to microsoft to don't underevaluating.
RE: Sudden increase in .pbix file size
Hello Sdjensen,
Any chance you have changed data types to date/time as part of those changes?
There are many scenarios this will do what you are describing
Thanks
chuck