Forum Discussion

jmartinezp's avatar
jmartinezp
Regular Visitor
9 years ago
Solved

No Sharepoint List detected

I have an Sharepoint 2013 list that I am trying to connect to using Power BI Desktop. I'm trying to connect to the source using Sharepoint List tool and introducing the URL address of my site at Shar...
  • Anonymous's avatar
    Anonymous
    9 years ago

    jmartinezp,

    Do you use the latest version of Power BI Desktop(2.47.4766.542)? How about you use the OData feed in Power BI Desktop to connect to the SharePoint list? You can enter the following URL in OData Feed entry, remember to change SITE_URL with the real URL of your site/subsite.

    http://SITE_URL/_vti_bin/ListData.svc



    Regards,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jmartinezp,

What authentication type do you use to connect to the SharePoint site in Power BI Desktop? Could you please check that if you have sufficient permissions on the SharePoint lists?

Regards,
Lydia

jmartinezp's avatar
jmartinezp
Regular Visitor
9 years ago

Hi Lydia,

I manage to connect using Windows authentication and my profile at SP2013 is defined as owner of the site with administrative privileges.

 

Regards,

Javier

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    jmartinezp,

    Do you use the latest version of Power BI Desktop(2.47.4766.542)? How about you use the OData feed in Power BI Desktop to connect to the SharePoint list? You can enter the following URL in OData Feed entry, remember to change SITE_URL with the real URL of your site/subsite.

    http://SITE_URL/_vti_bin/ListData.svc



    Regards,

    • jmartinezp's avatar
      jmartinezp
      Regular Visitor
      9 years ago

      It works using OData!!!!

       

      Thanks!!!!

      • Sokon's avatar
        Sokon
        Advocate V
        7 years ago
        Do you use the On-Prem Data Gateway as well? If yes, did you succeed in setting up a working data source to the On-Prem SP?