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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Element115
Super User
Super User

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 .

Sorry... done.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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