Data Loading Size

[Afiq_Danial]

Hi, 

I have two power bi files and both files are getting the data from the same excel file. The two power bi contains different contents and visualization. However, when I refresh my files, both of the files load different sizes but it shows the same number of rows loaded. Shouldnt the size be the same since its sourcing from the same excel file.

I'm referring to this size.

thank you

[Anonymous · Accepted solution]

Hi  @Afiq_Danial ,

Your two data contain different contents and visualization, so the content of the refresh will be different, because some operations in the power bi occupy different local resources, for example, the calculated column occupies the memory, while Measure occupies the CPU, so the size of the data used in the refresh will also be different.

Refer to:

Power BI - Calculated Columns Vs. Measures what’s the difference? (niichiconsulting.com)

Measure vs Calculated Column: The Mysterious Question? Not! - RADACAD

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Afiq_Danial , the rows loaded my be before the filter is applied in power query. Check actual rows in data view in status bar

[Afiq_Danial]

Hi, the number of rows in both files are correct. However, when i refresh my file, one file download shows 101mb from the excel file, while another file download only shows 38mb from the excel file. The excel files are the same