Forum Discussion
Helper IChanging 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:
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
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:
Hope this helps!!
Remember, special charecter type in file some times may cause error.
8 Replies
- shafiz_p
Super User
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-power-query/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- shafiz_p
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:
Hope this helps!!
Remember, special charecter type in file some times may cause error.
- tharunkumarRTK
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-power-query/
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!
pickup18Hi 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 😞
- tharunkumarRTK
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!
