Forum Discussion

pickup18's avatar
pickup18
Helper I
1 year ago
Solved

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:    ...
Need Help
Tutorial Requests
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    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.

pickup18's avatar
pickup18
Helper I
1 year ago

Yes it is only connected to excel from sharepoint

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

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!