undefined

[Anonymous]

Hi,

Im trying to connect power-bi to a excel file in Sharepoint. The file is in a private folder in Sharepoint and I have owner rights.

Documents is the private folder inside which the excel file is loacted.

If I use this URL=https://sites.xxxxxxxx.com/sites/Documents 

I get this error 

However, if I give the root URL. like this https://sites.xxxxxxxx.com , Im not able to navigate to the excel file.

How to access the file now?

Any help is appreciated. Thanks

[amitchandak · Accepted solution]

@Anonymous , Try like

refer for access

https://rukiatu.com/access-to-resource-is-forbidden/
https://community.powerbi.com/t5/Desktop/Get-Data-sharepoint-folder-issue/td-p/586727

how to connect

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-power-query/

[Anonymous]

You are a lifesaver. Thanks