Get data using sharepoint

[powerbidev123]

Hi Community,

Scenario: In my organisation, I need to pull an online sharepoint based excel file which is located in another user's account.  Need suggestion on how to go about this . 

I tried getting the file using web as source but the credentials don't work . I believe because of the file not being located in my personal sharepoint.

[Expiscornovus · Accepted solution]

Hi @powerbidev123,

Sounds like the file is located in a OneDrive for Business site (these are personal sites on the SharePoint platform) of another user, is that correct?

Assuming you have access to the file, have you made sure you copied the correct file path of the file? (see step 2 in the below instruction).

The steps for a OneDrive for Business sites with the Web Connector can be found in this Microsoft article:

https://learn.microsoft.com/en-us/power-query/sharepoint-onedrive-files#from-the-web-connector-using...

[Anonymous]

Here is a video that might help 

How to connect to a data file in a SharePoint folder in Power BI