Hello,
when doing ETL in PBI Desktop my Power Query is loading lots of data. Whenever I do a new step in the applied steps area, the litle lable in the bottom right corner shows a very high number of data being loaded, like 100mb. This takes very long. Sometimes it says not the amount of data bot the rows loaded. In that case its like 500000 rows loaeded. Why does this happen?
My preview feature is set to 1000 rows. I would expect that no more should be loaded.
This makes development very slow.
I would appreciate any help!
Greetings
Mike
@Anonymous - I have witnessed this behavior on Power BI files with lots of queries and relatively complex queries. I am not sure of the cause other than perhaps how the query is structured it has to load all of the rows in order to generate the preview. But, I agree it is highly annoying when it happens but I am not sure I have ever found a root cause for it.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
