Forum Discussion
Helper IICan't connect to Sharepoint subsites using PowerBI
Hi avelio,
Navigate to the home page of your subsite in browser, then copy the URL which is like: https://XXXX.sharepoint.com/sites/patrick/team1/SitePages/Home.aspx, then exclude “/SitePages/Home.aspx” part from the URL and enter URL like https://XXXX.sharepoint.com/sites/patrick/team1 in SharePoint connector in Power BI Desktop.
Thanks,
Lydia Zhang
Hi avelio，
Do you use the latest version of Power BI Desktop and which specific SharePoint connector do you use in Power BI Desktop? I use the SharePoint Folder and SharePoint Online list connectors to connect to SharePoint Online subsite, everything works well.
Thanks,
Lydia Zhang
Helper IIDear Anonymous, thank you for your reply!
My current version is Version: 2.45.4704.442 64-bit (April 2017).
I tried connecting using all 3 sharepoints data sources found in PowerBI (List,Online List and Folder). All of them work when i connect to the Site. If i try to connect to a Subsite i'm receiving the error: 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)".
My question to you is:
When your connecting to sharepoint to you type in the url https://Company.sharepoint.com/Site/Subsite or just https://company.sharepoint.com/Site/ and navigate from there to subsites?
Because if i connect to the site only, i dont have an option to navigate to subsites from there and if i try to connect to the subsites direectly i get the error i pasted before.
Any suggestions?
BR,
Andrei
Hi avelio，
I type in the URL: https://Company.sharepoint.com/Site/Subsite, in my scenario, the URL is https://xxxxx.sharepoint.com/sites/patrick/team1.
When you open your subsite URL in browser, does it work as expected? And does your subsite name contain slash or other specific characters?Thanks,
Lydia Zhang- avelio
Hello Anonymous,
When i type in the URL in browser it works as expected.
My subsite name is 'Reporting', it does not contain any specific characters.
The funny thing is that if i type in the exact url of the folder i want i get the following message
It specifically says to enter the site' root only :)
BR,
Andrei