Forum Discussion
recent .pbix size increase
I have been storing my .pbix files on a SharePoint site which has a 50MB filesize limit without issue for months. In the past two days, 2 of my .pbix files (not sure of their original size, but must have been <50MB) have balooned up to >80MB. There have been no structural changes to the files, and the increase in size is encountered simply by refreshing. The current source data is only marginally larger than before.
Has anyone else experienced this issue?
Hi Anonymous,
In addition to the size of the data source, the reasons for the increase of the pbix file include: too many calculated columns and calculated tables, hidden built-in calendar tables, and pictures in reports.
Would you please check if there are extra calculation columns and calculation tables. And for hidden built-in calendar tables. Please
uncheck the option in the screenshot below and restart the desktop:
Best Regards,
Dedmon Dai
5 Replies
- Perhaps you ran afoul of Power BI adding an automatic date hierarchy? That's generally when I see otherwise normal PBIX files go nuts with the storage.
Anonymous did you turned on enhanced dataset metadata don't expect size will drastically increase but just to see if that could be the root cause.
Hi Anonymous,
In addition to the size of the data source, the reasons for the increase of the pbix file include: too many calculated columns and calculated tables, hidden built-in calendar tables, and pictures in reports.
Would you please check if there are extra calculation columns and calculation tables. And for hidden built-in calendar tables. Please
uncheck the option in the screenshot below and restart the desktop:
Best Regards,
Dedmon Dai
