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

Hi Konstantinos

 

Thanks for the response.

 

I've tried connecting to the list directly from the Desktop app, but i'm getting an error connecting.

 

I'm assuming i should be using my Organizational Account to connect (have also tried Anonymous and Windows), but i get the following error:

 

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request.

Details: DataSourceKind=SharePoint

 

I'm guessing i've done something wrong but can't figure out what, any ideas?

Sorry for all the questions - i'm very new to PowerBI

 

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
11 years ago

GrahamKnowles  Probably you have found the solution so far ( please mantion the name @) as we don't see new post on old topics..

Maybe there is an error in the way you write the path..(although sharepoint lists always had problems connecting )..Check this please and change the "Documents" with "List" or similar  file name with list name.

https://medium.com/@Konstantinos_Ioannou/onedrive-powerbi-desktop-use-valid-paths-to-import-data-stored-in-onedrive-for-business-60089848e594

 

Coelijoeli In PBI desktop you choose basic and in PowerBI service oAuth2 for organisational accounts

 

.

  • 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?

    • MattViner's avatar
      MattViner
      Regular Visitor
      10 years ago

      This worked for me. 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