When applying, shows incorrect data size

[Anonymous]

Hello,

When I apply changes to my report, the data size shoes as around 10 GB, but the txt table weighs only like 100 KB. 

What could be the problem? 

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

I'm afraid that may be caused by your power query functions.  If you use many references in your power query, so the size will be large when you apply changes.

I’m not an advanced Power Query user but I think you can take a look at following two threads which related to Table.Buffer. Maybe it can help you.

http://community.powerbi.com/t5/Desktop/How-to-Improve-Query-Reference-performance-for-large-tables/...

http://community.powerbi.com/t5/Desktop/Queries-over-large-data-tables/m-p/26783/highlight/true#M852...

Best  Regards,

Cherry

[Anonymous]

I checked it out and it seems that the problem was in power query as you said. 

I used an index column to get to the cells I needed to, so i just took out that formulas with [index]{-1} etc. and it worked. 

Thanks!