Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Table.FuzzyNestedJoin Wasn't recognized BUG while using Dataflows

It appears that there is a bug in the ETL Dataflow process. I have two tables which I am trying to join using Table.FuzzyNestedJoin using the GUI interface. I click "Merge tables" and then folow the process to create a fuzzy merge. Once I click "OK"  the GUI then it enters all the necessary syntax. The problem is then I get the error that says: "The name 'Table.FuzzyNestedJoin' wasn't recognized. Make sure it's spelled correctly." @PhilipTreacy  has suggested this is a bug and I have tried in multiple workspaces and with multiple sources and with multiple different tables. Every time I get the same error which leads me to believe it is a bug as well.  The exact same code works great in the Desktop app. It just doesn't work in Dataflows. Can we expedite this fix? Thanks so much for your consideration. Below are some screen shots to help support what is happening:











Status: New
Community Support



I tried the Example but cannot reproduce the issue. Try the latest on-premises data gateway and create a support ticket for assistance if necessary.