User Profile

BartStens

New Member

Joined 3 years ago

6 Posts1 LikeLikes received2 Solutions

View All Badges

User Widgets

Contributions

Re: Loading delta tables into a lakehouse
Dear Anonymous , I was also struggling with exact same error msg. My headers followed requirements exactly as UTF-8 demands, but still got the error msg. Turns out I had to specify my column-seperator a.k.a. delimiter in the prompt when selecting the three dots near the file > "Load file in new table" then enter de correct delimiter used in your .csv-file, in my case a comma (,) was pre-filled in the prompt, but my .csv-file used (;) so had to adjust that one and load was succesfull! See below screencap (sorry it's in Dutch-UI)
2 years ago Place Data Engineering
11KViews
1like
0Comments
Re: 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.
3 years ago Place Dataflow
760Views
0likes
0Comments
Gen2 pipeline fails with source Excel files from Sharepoint folder - mashup error
Gen2 pipeline fails with source Excel files from Sharepoint folder, load into Lakehouse table. "Mashup Exception Data Source Error, foutdetails: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Failed to insert a table." I read a lot about the 'mashup' errors in this community, but all seem to involve an OnPrem or external source. But in this case it's all MS-cloud, as my ETL goes from a Sharepoint folder through a Gen2 PowerQuery into a Lakehouse table. On the workspace status page, I do see both the SharepointList as the Lakehouse have a valid connection status through OAuth2 on privacylevel organizational. Seems it has to do with 'Failed to insert a table.' As advised tried to create a support-ticket to MS through the admin-portal, but while filing it says 'failed to send the request, go to startpage and try again' while all requestform-fields are completed succesfully. As such, I'm posting my issue on this forum.
Solved
3 years ago Place Dataflow
Dataflows
786Views
0likes
1Comment

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.