Forum Discussion
avelio
Helper II
Helper IICan't connect to Sharepoint subsites using PowerBI
Dears, Currently i'm experiencing the following issue: - My organization is keeping files on sharepoint. - Im trying to use PBI to connect to our sharepoint files - When i'm connecting to h...
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
It still does not work when i try to connect to on prem sharepoint list like: http://intranet.contoso.com/subsite using get data from sharepoint lists. But it works when i use get data from web and enter the above url. Any ideas?