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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
pickup18
Helper I
Helper I

Changing data source from local excel to excel from sharepoint, files corrupted [binary]

Hi all,

 

I recently change the sources of my file from a local excel workbook to a sharepoint folder from our oragnization site. However, after doing this, it keeps returning this error: 

 

DataFormat.Error: File contains corrupted data. Details: [Binary]
 
At the same time i created a gateway service for my files in power bi service so i can turn on automatic refresh and it has also been returning an error:
 
Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: NS.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 1e9d0351-a3ca-4908-bbb0-603ec4df2c0a
Request ID: 4782d710-02d9-4366-b741-df0c40bcddbf
Time: 2024-09-12 23:12:30Z

please help i only have a day left to fix this
1 ACCEPTED SOLUTION

okay, if you have used sharepoint folder as a connector then try changing to web connector. First clear cache memory. Then go to sharepoint and click 3 dots and select details. A pane will open in the right side and copy path. Paste in to the url field of web connector. See image below:

shafiz_p_0-1726337605447.png

 

 

shafiz_p_1-1726337705663.png

 

Hope this helps!!

 

Remember, special charecter type in file some times may cause error.

View solution in original post

8 REPLIES 8
tharunkumarRTK
Super User
Super User

@pickup18 

 

Please verify if the excel file is protected with a password. If that is not case then please verify the sensitivity label of the excel file. If it is an encrypted sensitivity lable then please change it to an unencrypted label. 

Chris webb has documented these two possible reasons: https://blog.crossjoin.co.uk/2024/06/16/the-dataformat-error-file-contains-corrupted-data-error-in-p...

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!


PBI_SuperUser_Rank@2x.png

Hi @tharunkumarRTK thanks for the reply but same with shafiz:

 

1. my documents are not corrupted i can open it in sharepoint

2. it is not password protected

3. there's no sensitivity label, anyway im using power bi query

 

right now its still returning the same error 😞

@pickup18 

 

1. Is your excel file connected any other file through power query in excel? if yes what is the sensitivity labels of those files?

2. Have you signed into your power bi desktop?

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!


PBI_SuperUser_Rank@2x.png

Yes it is only connected to excel from sharepoint

You have connected to an excel from Power BI desktop, lets assume that file name as DataSample.xlsx. 

Open DataSample.xlsx, click on the Data tab and click on 'Queries and connections' there you will be able to identify if this file is connected to any other file. Incase if it is connected to any other file, just verufy the senstivity labels of those files. 

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!


PBI_SuperUser_Rank@2x.png
shafiz_p
Resident Rockstar
Resident Rockstar

Hi @pickup18  Considering you have used Sharepoint Folder Connector. Please check you have correct data types. Some times special charecter may cause this error.

Try reading this blog for other scenarios:
https://blog.crossjoin.co.uk/2024/06/16/the-dataformat-error-file-contains-corrupted-data-error-in-p... 

 

For gateway issue, refer to this video: https://www.youtube.com/watch?v=Y9Dc7jd5VaI 

 

Hope this helps!!

If this solved your problem, please accept it as a solution!!

 

Best Regards,
Shahariar Hafiz

 

hello @shafiz_p thanks for your reply

 

1. my documents i not corrupted i can open it in sharepoint

2. it is not password protected

3. there's no sensitivity label, anyway im using power bi query

 

right now its still returning the same error 😞

okay, if you have used sharepoint folder as a connector then try changing to web connector. First clear cache memory. Then go to sharepoint and click 3 dots and select details. A pane will open in the right side and copy path. Paste in to the url field of web connector. See image below:

shafiz_p_0-1726337605447.png

 

 

shafiz_p_1-1726337705663.png

 

Hope this helps!!

 

Remember, special charecter type in file some times may cause error.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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