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

     

     

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

aditirdatta's avatar
aditirdatta
New Member
9 years ago

Is this PowerBI online that you are referring to here OR the desktop version? Thanks!