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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

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

Yes Anonymous!

It works.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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