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. This can occur for a number of reasons and does not necessarily imply that the data does not exist or is of a default value.
Details:
Property=AssignedTo
However, if I run the URL directly in a browser, I get all the data returned correctly including the AssignedTo column.
Any idea what might be happening here?
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.
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.
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
I cleared all permissions (global and current file) in File->Options and settings->Data source settings, and cleared cache in File->Options and settings->Options->Data Load, but still getting the same problem.
Not sure what you mean by data type changes. AssignedTo is a built-in field, and I'm using the sample query mentioned.
Any thoughts based on my last message?
Hi Anonymous ，
You could read the following article ,it may be helpful for you!
Guy in a Cube – How to expand a list of records in a query
Best Regards
Lucien
