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

     

     

GrahamKnowles's avatar
GrahamKnowles
Icon for Resolver I rankResolver I
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

 

 

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

I tried linking to a particular table in sharepoint after navigating throug the root site. But after selecting the table, I am getting an error of 'User is not Authorized'. I have read access to the sharepoint list and I have a sharepoint license. What other access do I need?