Forum Discussion
.pbix size
hi, i want to know what effects the size of the .pbix file i know that the # rows (if data is imported) but what abput the query? the tabs? the visuals. i feel like the size of the file is getting...
Obviously the amount of data you import will have an effect. This will be the biggest driver.
PBI Desktop is a tabular cube which will compress the data, however this won't work well on fields that are highly unique (such as ID fields and DateTime fields that include Day/Hour/Min/Sec)
So have a look at the tables with the most rows and see what columns you can avoid brining into your model.
Often you can remove quite a few columns and still create SUM/COUNT/AVERAGE measures that satisfy your reporting needs.
Your model will be faster too.
This is a very good video which is 100% releveant to building models in Power BI Desktop.
https://www.youtube.com/watch?v=dgzJPQ2-F5s