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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Element115
Impactful Individual
Impactful Individual

BUG::Invalid: Parquet magic bytes not found in footer, OLE DB or ODBC error: [DataFormat.Error]

ISSUE:

After connecting successfully to a Fabric lakehouse table via the Azure Data Lake Gen2 from Power Query Desktop, the following error messages are emitted by Power BI Desktop when applying the changes:

 

Query1
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] Parquet: class parquet::ParquetInvalidOrCorruptedFileException (message: 'Invalid: Parquet magic bytes not found in footer. Either the file is corrupted or this is not a parquet file.'). '.
Query parameters
Parameter2
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] Parquet: class parquet::ParquetInvalidOrCorruptedFileException (message: 'Invalid: Parquet magic bytes not found in footer. Either the file is corrupted or this is not a parquet file.'). '.

 

STEPS:

Assumptions:  You have created a Fabric lakehouse and already populated it with at least one table.

 

0__in Power Query Desktop, Home>New Source>More>Azure.

1__select Azure Data Lake Gen2 in the right pane and then click Connect.

2__navigate to your Fabric lakehouse and click ...>Properties.

3__copy the https URL.

4__navigate back to Power Query Desktop and paste the URL in the dialog into the 'File' textbox under 'Data view' and click OK.

5__click the 'Combine and Transform Data' button in the new dialog that pops up.

6__a new dialog opens up titled 'Parquet' presenting a view of the data; all looks good; click 'OK.'

7__a preview of the data loads fine inside the Power Query Desktop editor. Click Home>Close and Apply.

8__you are back in Power BI Desktop and the 2 error messages above appear in the dialog titled 'Load.'  You cry yourself to sleep.  😓

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

2 REPLIES 2
lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Element115
Impactful Individual
Impactful Individual

Sorry... done.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.