Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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() ).
@Anonymous ,
You may also try RANKX in DAX.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |