Forum Discussion
Resolver IPowerBI linked to SharePoint Lists require a Personal Gateway?
Yes Konstantinos, i have this working now.
My problem was i was trying to connect to the exact link for the sharepoint list. In order to correct i had to change this link to the general site address and once connected to the site in PBI Desktop select the sharepoint list from the list of available tables to load the data.
Thanks
Helper IIerikskov thanks for the tip.
My sharepoint URL is like this https://companyname.sharepoint.com/Site. If i type this url in i can connect just fine. The problem is that in this folder i have subsites and those are the folders that contain actual data (.xls .csv). If i type https://companyname.sharepoint.com/Site/Subite in the url which connects me to the sharepoint i get the follow 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)"
So, it's not enough to connect to the Sharepoint Site because thats not where my data is. It's stored in subsites and apparently i cant connect to those.
Moreover if i use PBI web app i can connect just fine to the site and then i can browse my sites/subsites and select which excel i want to use to retrieve data. This feature is not available on the desktop app.
To conclude:
- Using PBI desktop i can connect to sharepoint online site (https://companyname.sharepoint.com/Site) but cant drill down from there to subsites which is where my data is
- Connecting to the Subsites in my organization is not possible (error retrieved: 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)"
Anyone else experiencing this problem?
Is there a solution?
- Using PBI web app i can connect to my sharepoint site and from there browse my subsites to retrieve data.
Advocate II404 Usually refers to a File Not Found, so I'm guessing the URL is incorrect.
I can access my O365 site and subsites from within Power BI Desktop directly. To illustrate, I navigate to Site Contents and select Subsites:
Then, by selecting the 'Help Center' site and select site contents, get the full URL: https://catsysdemo.sharepoint.com/sites/fusedeverikskov/helpcenter/_layouts/15/viewlsts.aspx?view=14
I paste that URL (minus the page info) into Power BI O365 Sharepoint List data connector, authenticate, and huzzah...there's my contents.
I've wasted two hours today trying to be more productive at work by standing up a super simple power BI that connects to an excel file which I should be able to keep on my sharepoint folder. but no, that's not possible at least having searched for two hours now. I have an excel file and I don't know where I can put it where it will actually be of any use. does anyone have a plan for this seeming insanely simple and every day need?