Forum Discussion
Get data using sharepoint
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.
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:
2 Replies
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:
