Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DataFormat.Error on AssignedTo column running basic OData query

I'm using this sample query, and getting the following error on the AssignedTo column: DataFormat.Error: We expected a property 'AssignedTo', but the OData service omitted it from the response data....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    After some investigation with Renata Popescu (Power BI Support Engineer) and Ludovic Fry (Incident Manager) from Microsoft, it was suggested to remove OmitValues = ODataOmitValues.Nulls from the query. This fixed it.

    It appears that the sample query assumes there are only non-null values, and will therefore omit null values. Removing this part of the query ensures that null values are considered valid, and therefore removes the error.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Few things you need to check

1) Edit connection, clear cache, and try to give credential again

2) Under option and setting there is clear cache use that and check

3) Check for any data type change and try to address that.

 

If nothing works out, please let us know

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Any thoughts based on my last message?