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
Hi,
Were you able to find a solution for this?
Entering the site's url, only shows 'Document Libraries', but not lists.
Thanks,
laura
Microsoft EmployeeSamw problem faced by us in Power BI service
- erikskov
Advocate II
Power BI can connect directly to a SharePoint O365 list.
To do so, select Get Data, 'More', Online Services, and SharePoint Online List. Click Connect and enter your base site URL. You will then be prompted to login using your Organization credentials. Once logged in, you should now see a list of items whilch should include any lists you have created. In my example, you can see the 'Custom List'.
avelioHelper II
erikskov 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.
- erikskov
404 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.
Is this PowerBI online that you are referring to here OR the desktop version? Thanks!
Can you please go into detail about how to move your page analytics into a custome report?
