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 User
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
|
Helper IYes it is only connected to excel from sharepoint
- tharunkumarRTK
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!