Slowness of editing in Power Query - loading MDW (SQL)

[Anonymous]

Hi guys, 

I have an issue with slowness of editing, it takes forever. In the right corner is showing how many rows are loaded from DSN = MDW.

I am sure that query doesn't contain so many data.

Power Query contains 6 tables - 1st table loaded data from file - just few rows

2nd table - contains SQL data

3nd,4th and 5th table - contains data also from previous tables - their are connected through merge etc.

Could you please help me to resolve it? 

[BA_Pete]

Hi @Anonymous ,

Your 3rd, 4th, and 5th tables will have to load all the rows from the previous tables as they contain merges. Merges are essentially 'whole table' operations that require both tables in each merge to be fully scanned, thus your row count and process time gets very high.

The fastest way to resolve this is by not doing the merges at all, but relating the tables in the data model instead.

Pete