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

djeepy1's avatar
djeepy1
Advocate I
10 years ago

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

  • djeepy1's avatar
    djeepy1
    Advocate 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