Fuzzy Nested Join Extremely slow

[afrantz]

The final step of a very long analysis in powr querey editor is a Fuzzy Nested Join.  It takes hours to load, but is only around 44 MB.  I have a duplicated table that has all the same steps minus the Fuzzy Nested Join and is the same size, but only takes a few minutes to load.  This is a necessary step for me, but is just not feasible if it will never load. 

[v-yuta-msft · Accepted solution]

@afrantz ,

How many columns are there in your table, too many columns may slow down the performance more than rows. In addtion, you may refer to doc below about how to improve the performance in power query:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.