Forum Discussion

3sun_Jack's avatar
3sun_Jack
Regular Visitor
10 years ago
Solved

Connecting to a SharePoint List Office 365 error

Hi I am receiving the following error when I try and link a SharePoint site to Power BI   DataSource.Error: We couldn't parse OData response result.  Error: A null value was found for the property ...
Need Help
  • kompas_ua's avatar
    kompas_ua
    10 years ago


    I changed the ApiVersion from 15 to 14 in the Query Advanced Editor, and it works now =)

    let
        Source = SharePoint.Tables("https://###.sharepoint.com/teams/Team020/", [ApiVersion = 14]),
        ProjectList = Source{[Name="ProjectList"]}[Content]
    in
        ProjectList

rgparisoto's avatar
rgparisoto
Icon for Helper I rankHelper I
10 years ago

Hi djeepy1! The Power Bi return me this:

"The User was not authorized"

 

 

I don't know how to fix it. :smileysad:

  • djeepy1's avatar
    djeepy1
    Icon for Advocate I rankAdvocate I
    10 years ago

    If you test the URL in a browser (being previously logged in O365), does it work ?

      • djeepy1's avatar
        djeepy1
        Icon for Advocate I rankAdvocate I
        10 years ago

        When you type URL in OData feed, Power BI Desktop should prompt for authentication (O365 windows). Be sure to choose OAuth authentication.

         

        Can you verify you have the lastest version of PBI Desktop ?

        Did you use the OData Feed source in Get Data menu ?

        You can also check on in Data Source Settings window if Authentication is correct.

         

        JP