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

     

     

Rajiv's avatar
Rajiv
Icon for Advocate I rankAdvocate I
10 years ago

I have done exactly the same thing as Graham, only difference is that I am using PBI online that comes with my Office 365 subscription. Is it not possible to link the PBI online report to a SharePoint online list?

 

Also, the refresh does not seem to be working as expected. I am using a stacked bar chart on PBI dashboard and after refresh all of the data is not reflected in the chart. But when an individual item is clicked and gets highlighted, the missing data shows up in the faded stacks. I hope I am making sense here!

 

Could this be because of any limits on the number of items you can have in a stacked chart? The chart looks fine in the Excel file imported from the list, but not on the PBI dashboard.

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