Forum Discussion
Helper IChanging data source from local excel to excel from sharepoint, files corrupted [binary]
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.
Super UserHi 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
pickup18hello 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 😞
- 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.