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
9 years ago

404 Usually refers to a File Not Found, so I'm guessing the URL is incorrect.  


I can access my O365 site and subsites from within Power BI Desktop directly.  To illustrate, I navigate to Site Contents and select Subsites:

Then, by selecting the 'Help Center' site and select site contents, get the full URL:  https://catsysdemo.sharepoint.com/sites/fusedeverikskov/helpcenter/_layouts/15/viewlsts.aspx?view=14

I paste that URL (minus the page info) into Power BI O365 Sharepoint List data connector, authenticate, and huzzah...there's my contents.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I've wasted two hours today trying to be more productive at work by standing up a super simple power BI that connects to an excel file which I should be able to keep on my sharepoint folder.  but no, that's not possible at least having searched for two hours now.  I have an excel file and I don't know where I can put it where it will actually be of any use.  does anyone have a plan for this seeming insanely simple and every day need?