Loading file from sharepoint

[ktt777]

Can i load excel file from sharepoint if it is not in any folder like below?

[Anonymous]

You can add by using web option in power bi get data and from sharepoint click on the right most 3 dot and copy the path and paste direclt into web.

[amitchandak]

@ktt777 ,

I tried the first option for both one drive and SharePoint excel worked for me. You can refer one of the two

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

https://www.poweredsolutions.co/2019/04/04/connecting-to-files-in-sharepoint-onedrive-with-power-bi-...

[rubinboer]

yes you can. open the file with the desktop app (eclipse and open with desktop app) once open in excel go to Info and copy the path to the clipboard. in the datasource within power bi select excel as source and paste the location which you copied to the clipboard as the path https://drherjeilrtjew.xlsx?web=1. remove the ?web=1 part. i am assuming the site is already to IE to allow Power Bi to access SharePoint.

[ktt777]

Thanks. 

I tried that but there is below error when i load the file :

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

Do you have any idea why ?

[rubinboer]

please make sure you select excel as the source and not SharePoint online. the error you get look slike you trying to get data from a SharePoint online list.

[ktt777]

Hi

If i choose Excel as source, where can i paste the link that you mentioned earlier ?

Thanks.

[V-lianl-msft · Accepted solution]

Hi @ktt777 ,

Refer to this document, similar to this approach

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deepanshuarc]

Does this work for sharepoint as well

[rubinboer]