Forum Discussion
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 https://companyname.sharepoint.com/Site1/ it works just fine. The problem is that my data is stored into Subsites, so it goes something like this https://companyname.sharepoint.com/Site1/Subsite2.
- When i'm connectong to the subsite i get the following 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)"
- If i use GetData from PBI Web App i can connect to the Site (https://companyname.sharepoint.com/Site1) and browse from there our subsites and select the data.
Question:
Why isnt this feature possible for PBI Desktop App?
Am i doing something wrong?
How can i connect the data from my subsites on sharepoint to powerbi desktop?
BR,
Andrei
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
20 Replies
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
avelioDear 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
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.- avelio
Hi 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
- avelio
Dears,
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 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 ZhangHi, my PBI is in portuguese so I may mistranslate something, hope you understand it: when I follow the proposed solution I receive a message saying "The Resource is Forbidden" (or equivalent in English). Do you know if this is SharePoint permission related?
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.
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?
