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

karo's avatar
karo
Advocate V
7 years ago

Any news regarding this error from the Microsoft side?

abhijeet01's avatar
abhijeet01
Frequent Visitor
6 years ago

bit late to this forum, posting what we tried in team, and could be helpful to few new ones.. 

 

when I was getting error, 

1) cleared all my attempted data source connections 

PowerBi -> File -> Options and settings -> clear permissions to sharepoint folder

 

2) connected again 

Get Data -> SharePoint Online List -> https://xxx.xxx.com/sites/companyName/lean
(my datalist is coming from https://xxx.xxx.com/sites/companyName/lean/Lists) 
PS: Use correct onganisational account to connect and you need right permissions in sharepoint (https://docs.microsoft.com/en-us/sharepoint/understanding-permission-levels) 
view only permission didn't worked so i requested "Read" and succeeded. cheers !!!