Forum Discussion
OData.Feed returns duplicated rows
Hello,
I'm using the OData.Feed conector to get data from Dynamics CRM custom app.
The problem is when running the query bellow (appended to the uri string) using the OData.Feed and an $expand statment its duplicating all the rows from the expanded table.
If I run the same request with the Web.Contents conector it works fine, so Im guessing it may be a problem with the OData connector?
2 Replies
Hi Anonymous ,
Refer to :
https://stackoverflow.com/questions/37988892/odata-expand-and-select-queries-in-url
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous ,
Thank you for your reply!
I'm using the step "Query2" as part of the URI string, not the Query options, I just call it query 🙂
Ive tried out some tests with other sources and the problem didnt occur, so my guess is its some problem with my Dynamics CRM source (witch I cant change).
I've simplified the problem so its easier to read, you can see in the image that the result is returning 4 rows, with 2 duplicates of each "stakeholderId", this shouldnt happen as this field is the unique value of the expanded table, and this specific project only has 2 stakeholders (json response from the same request below)
powerBI:
correct response: