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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Element115
Power Participant
Power Participant

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.