Forum Discussion

GrahamKnowles's avatar
GrahamKnowles
Icon for Resolver I rankResolver I
11 years ago
Solved

PowerBI linked to SharePoint Lists require a Personal Gateway?

I've got a list created in SharePoint online which i want to use to display data into a PowerBI report.   I've connected the list into an excel spreadsheet through the Export to Excel option in the...
Need Help
  • GrahamKnowles's avatar
    GrahamKnowles
    11 years ago

    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

     

     

Rcharles's avatar
Rcharles
New Member
10 years ago

Similar to the previous post, I am trying to report on my Office 365 online Sharepoint site list.

 

I am able to create a link to my online sharepoint site. However, I see only document folders.  I do not see any reference to my sharepoint list. My hope is that I can graph the required metrics off my List data. What am I missing?

 

I do not want to extract the data to Excel and then push this back to the site for reporting...

 

An help will be appreciated.

lapfama's avatar
lapfama
New Member
10 years ago

Hi,

Were you able to find a solution for this?

Entering the site's url, only shows 'Document Libraries', but not lists.

 

Thanks,

laura

  • mcallough's avatar
    mcallough
    New Member
    10 years ago

    I am seeing the same error. I see my Document Libraries but no lists. 

  • Ramakrishnan's avatar
    Ramakrishnan
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Samw problem faced by us in Power BI service

    • erikskov's avatar
      erikskov
      Icon for Advocate II rankAdvocate II
      10 years ago

      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'.

      • avelio's avatar
        avelio
        Icon for Helper II rankHelper II
        9 years ago

        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.