Get data using 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:

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