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

     

     

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

You need to import/connect  the sharepoint list direct to PBI Desktop..The way you do it now it fetces the data from local excel file , that is why you need a Personal DMG..The connection that PBI desktop uses now to refresh is the connection to local excel, cannot pass the connection from sharepoint list that you store in local excel ..

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?