Forum Discussion

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 ...

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

Helper I

10 years ago

Thanks for posting the question and the subsequent answer. Would be great to see this fixed.