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
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.
Helper IIAnonymous Well that is the problem. In PBI Desktop if i specify the full path i get the error that i've posted. In PBI Desktop i can only specify https://companyname.sharepoint.com/Site1/ for it to work.
BR,
Andrei
Ok i've run some testing this morning, coincedently because a staff member also needed to do this today. Here is what we did and it worked.
Select new data source and choose "SharePoint Folder" or "SharePoint List" depending on what task you are performing. Choose https://companyname.sharepoint.com/Site1/ and then locate the files/lists as they appear in this list. Everything should be in here for Site1. On mine there is a "Folder Path" column which might help you filter down.- avelio
Anonymous this is what i get if i try to reproduce your steps (sharepoint folder).
There is no possibility to drill down to subfolders from here. It just retrieves some nonsense data.
Does it have anything to do with the structure of the sharepoint folders/subfolders etc?
The weird thing is that in app.powerbi.com works just fine...
If i choose sharepoint list i get the following screen.
I can check/uncheck the subsites on the left side, but the information in it is nonsense, i should be able to browse to those subfolders and select a worksheet.
BR,
Andrei
It depends whether you are using Lists or Files. Based on your original description, files will be what i imagine you need.
Have another look at your files list and there should be a column called "Folder Path". You should be able to use this to find the files in your subfolders. Essentually all of the files are there in that single list.