Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All
I have a PBI sample file , i have remove all the Table left with 1 row recode.
But the file size 4,777KB.
it thee any way i can further reduce the file size to 1,000KB ?
Below link is my PBI sample file :-
https://www.dropbox.com/s/krpoqejhylw7d96/PBT_V2021_371%20sample%20data%20only%201%20row.pbix?dl=0
Paul
Solved! Go to Solution.
Hi @admin11
Do you insert some images / custom visuals / other elements into the report? If yes, they will also occupy some space.
You may refer to this blog to convert your pbix file into zip file and find out which contents occupy most of its data size. For example, the DataModel file is the file that actually stores all of your data in tables. I create a blank PBIX file and its DataModel size is 32KB as below. You may create a copy of your sample file to check this.
Regards,
Community Support Team _ Jing
What happend when you turned off the auto time intelligence? The other thing you can do is to connect using DaxStudio and use Vertipaq Analyzer to look at which tables and columns are taking up the data. I show you how to do that in this article https://exceleratorbi.com.au/external-tools-in-power-bi-desktop/
Thank you for sharing your blog post , very useful.
I stuck because when intsall Dax studio i get below error :-
I have try to restart my PC and install again , i still get the same above error.
Paul
Hi @admin11
Do you insert some images / custom visuals / other elements into the report? If yes, they will also occupy some space.
You may refer to this blog to convert your pbix file into zip file and find out which contents occupy most of its data size. For example, the DataModel file is the file that actually stores all of your data in tables. I create a blank PBIX file and its DataModel size is 32KB as below. You may create a copy of your sample file to check this.
Regards,
Community Support Team _ Jing
Thank you very much for your sharing.
i just check , most of the memory is from data model. So look like the data still store in the PBIX file. which not allow to delete.
Paul
Could you please remove all unwanted columns and calculated columnsin the all tables and try. For example in the Target 16 we have column1, _1,_2
thank you for your sharing.
I have try to delete about total 8 input table for example segment , target , rate etc ,
The file size remain the same.
Paul Yeo
I can't access the file as I am on an iPad. Chances are this is a calendar table issue. Go to
file
options
options and settings
Current workbook
Turn off Auto time intelligence.
save the workbook and check the size again.
I have check and notice the Time intellient is not turn on :-
After i clear the chash and save , The file size still the same.
Paul
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |