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

 

 

sdeoghar's avatar
sdeoghar
Frequent Visitor
9 years ago

Hi 

 

did you happend to get this issue resolved. I am facing this error while connecting Sharepoint list directly to power BI.

 

My web address is of extranet, so is this an issue? can you suggest.

 

I want to make sharepoint list and power BI connected directly, but unable to do so.

 

Shivjeet Deoghare