Forum Discussion
Gen2 pipeline fails with source Excel files from Sharepoint folder - mashup error
UPDATE: sorry members for claiming your precious time to read my post. Just tried a bunch of workarounds to get the issue fixed. First was to remove all excisting connections from within the PowerQuery editor. As I read the error message 'Failed to insert a table' so thought it canot create a table in Lakehouse.
But the error log was deceptive as it didn't have to do with the Lakehouse but just with the query itself. Added a 'replace all errors with null' for all columns in the query. Seemed some rows needed column type 'any' but that ain't supported yet, and text didn't solve it. Now I've had a succesfull load.
Member123456 Post can be closed.
UPDATE: sorry members for claiming your precious time to read my post. Just tried a bunch of workarounds to get the issue fixed. First was to remove all excisting connections from within the PowerQuery editor. As I read the error message 'Failed to insert a table' so thought it canot create a table in Lakehouse.
But the error log was deceptive as it didn't have to do with the Lakehouse but just with the query itself. Added a 'replace all errors with null' for all columns in the query. Seemed some rows needed column type 'any' but that ain't supported yet, and text didn't solve it. Now I've had a succesfull load.
Member123456 Post can be closed.