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

sAlexRUS's avatar
sAlexRUS
Regular Visitor
10 years ago

Tell me please
Why does not this request?

 

let

    soursOData = Data.Feed("https://<app web url>/_api/web/Lists(guid'DEE5D045-C8AB-4878-B3F1-0D814EBF648E')/Items?$select=TextMonth,TextQuarter")

in 

  soursOData

 

Error OData.Feed

P/S/

This code is working in the browser

djeepy1's avatar
djeepy1
Advocate I
10 years ago
You get a HTTP 404 error on /$metadata resource of your list on your SharePoint.
I'm not a SharePoint expert but maybe there's some specific setting on your list (or permission missing).