200 MB from XXX.csv when XXX.csv weights 11 MB ?

[Anonymous]

Hello,

My Power BI Desktop takes so long to refresh data, I see at the bottom 150+ MB from X.csv when that file weights just 11 MB. Why does this even happen ?

Thanks.

[Anonymous]

HI @Anonymous ,

Are you sure you are only refreshing that csv file. I want to know, Have you performed any append query operation in that CSV?

Ideally, it's should not show 150+ MB file size for 11MB raw file size data.

Please investigate , also check relationship section, it's something wrong with your data.

Thanks,
Amit

[Anonymous]

This is actually when I use the List.Max(#"Added Index"[Index]) that it's getting crazy.  I want to divide each index value by the biggest index (to have the equivalent of Excel PERCENTRANK() ).

[v-chuncz-msft]

@Anonymous ,

You may also try RANKX in DAX.