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

[admin11]

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

[MattAllington]

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/

[admin11]

@MattAllington 

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

[v-jingzhang · Accepted 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

[admin11]

@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.

Paul

[Singaravelu_R]

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

[admin11]

@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]

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. 

[admin11]

@MattAllington 

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