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
I've had this experience myself. From my research you can only link your Gateway to the first site1 level and your data gateway should be able to reach down to those other levels.
I have no idea why SharePoint and Power BI are set up like that. It certainly work though if you just link to that site 1 level.
Helper IIHi Anonymous! I sure am glad im not the only one experiencing this issue.
The problem is that from PowerBI Desktop i cannot reach down other levels, only in app.powerbi.com and as a developer this doesnt help. :(
I'll create a support ticket and see what happens.
Thanks,
Andrei
I've found that if you set your desktop version to link to the full path, but your On-Premise Gateway on the online portal to link to the higher up Site1, they all work out fine.
- avelio
Thanks Anonymous but i'm not quite sure i understand what are the steps i need to take to get there.
Can you explain please as you would a dummy?:)
When you are in the PBI Desktop, you'll need to specify the full path to draw down your data. Your PBIX file will store that as your data source.
When you set up your On Premise Data Gateway in Power BI Web, you'll select your data source as Type: SharePoint and have a path of https://companyname.sharepoint.com/Site1/
When you publish your Power BI desktop to your Power BI Web, the data gateway is smart enough to recognise it has access to that full path, because you gave it access to the higher level.