Forum Discussion

afrantz's avatar
afrantz
Frequent Visitor
7 years ago
Solved

Fuzzy Nested Join Extremely slow

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 th...
  • v-yuta-msft's avatar
    7 years ago

    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.