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
Helper IIDears,
I've been struggling in the past week to connect PowerBI Desktop to sharepoint online to extract some data from excels.
I've encountered the following problem:
- When connecting to the sharepoint site https://company.sharepoint.com/Site cannot browse further my companys subsites in order to select the data that i need. I get the following screen:
In this screen if i select the subsites on the left i get nonsense data in the right. My data should be in these subsites in the form of excels.
If i try to connect directly to the subsite i get the following error:
https://company.sharepoint.com/Site/Subsite
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)"
If i type in the full path of my folder i get the following message:
The weird thing is that if i follow the same steps in app.powerbi.com i get a screen in which i can browse my subsites/folders and get my data.
I want to do this in PBI Desktop, not Web.
Any thoughts?
I'm mentioning that i have the latest version of PBI Version: 2.45.4704.722 64-bit (April 2017)
BR,
Andrei
Hi Andrei, Power BI is actually now up to May, but it shouldn't impact what you are attempting.
In Power BI Desktop, use the "SharePoint Folder" as your get data connection type. Provide it the URL without the "SubSite" portion.
The "Non-Sense" data you are seeing looks to be the SharePoint metadata and there should be a column that has the Binary in it. You can select the binary in the value cell and it should open the document.