Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
admin11
Memorable Member
Memorable Member

My PBI sample file only 1 row of record and only 1 Tab how to reduce the file size ?

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

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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.

031902.jpg

Regards,
Community Support Team _ Jing

View solution in original post

8 REPLIES 8
MattAllington
Community Champion
Community Champion

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/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

@MattAllington 

Thank you for sharing your blog post , very useful.

I stuck because when intsall Dax studio i get below error :-

admin11_0-1616194398564.png

I have try to restart my PC and install again , i still get the same above error. 

 

Paul

v-jingzhang
Community Support
Community Support

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.

031902.jpg

Regards,
Community Support Team _ Jing

@v-jingzhang 

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.

admin11_0-1616154889468.png

 

Paul

 

Singaravelu_R
Resolver III
Resolver III

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

 

Singaravelu_R_0-1615972289004.png

 

@Singaravelu_R 

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

 

MattAllington
Community Champion
Community Champion

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. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

@MattAllington 

 

I have check and notice the Time intellient is not turn on :-

admin11_0-1615972614878.png

After i clear the chash and save , The file size still the same.

 

Paul

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.