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.
Helper Ihello 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 😞
Super Userokay, 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.