Power Query Editor doesn't load even small tables and occupies ressources

Hi everyone,

sorry for the late reply, i was hesitating to post my code because of Colleagues Names in the calculated Columns. We fixed the issue by ourselves, by building again.

Solution:

Many of our Tables had many Steps (30+): So we grouped them. (I think that was the biggest factor. Now each function has only to be called once?)

Much data was unnessecarily loaded: We already filtered in the Dataflow and used the Query editor only for modeling

If you come upon this on your search i can only emphasize on grouping your steps in the Query editor and using the reference option if possible when "copying" a table. And be careful on deleting steps that later steps could rely on. Guy in a Cube also has some helpful content regarding performance issues.

Thanks everyone for all your help,

Best regards