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

lelenko's avatar
lelenko
New Member
9 years ago

Hi,

can you please give any more specific information on how we could do that? :)

kompas_ua's avatar
kompas_ua
Advocate I
9 years ago

Hi lelenko,

 

What is your problem about? Do you struggle with extraction data from SPO list, which has a many lookup and multi-lookup fields? Here "many" means more then threshold.

 

BR, Sergey