Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

.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...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi MP_123,

 

Some great tips from Greg_Deckler and Phil_Seamark, the other consideration I would also say is to make sure you change the column data types to ensure that they are the correct types, as well as being the most efficient. 

 

For example if you have a column with Dates, and the column data type is set to DateTime, rather change it to Date, as this will take up less space. The same can go for number values and as suggested before is the Text based values. 

 

Another tip to ensure that the .PBIX file is as small as possible is if you have any data in your Query Editor that is used for generating other queries but is NOT required in your Power BI Model is to disable the loading of this data. Here is a great blog post by Rezza Rad explaining this Performance Tip for Power BI; Enable Load Sucks Memory Up