Invalid JSON error when retrieving data from published OData service
0
After publishing an OData service with multiple entities (endpoints), I'm having issues fetching data from one of the entities in Excel or Power BI. When I try to load the data in Excel, I receive the error message "Invalid JSON. More than one value was found at the root of the JSON content". See attached screenshot with the complete error message. The same error message is shown in Power BI when loading the data from the endpoint. This error is only occuring when reading data from Production, not from Acceptance. Reading data from the same endpoint on Acceptance can be done without errors, so it seems this issue is related to the data that is published via the endpoint on Production. What could be the problem here?