Failed to Generate Query Plan · Learn Microsoft Fabric

Failed to Generate Query Plan

I'm writing a stored procedure as part of my ETL into a Fabric Datawarehouse. I have the data in tables in the DW and use a view to shape it for upsert into the Dim table, however, I'm getting an error when I try to update the data. I don't get the error when inserting data.

Request to perform an external distributed computation has failed with error "100001;Failed to generate query plan."

This error doesn't make sense as everything is located within Fabric. Google was no help as others were using external data sources to perform complex transformations. I'm writing a simple Update statement when the data matches. Any suggestions on what to look for?

4 comments