OData.Feed returns duplicated rows

[Anonymous]

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?

[Anonymous]

Hi @Anonymous ,

Refer to :

https://stackoverflow.com/questions/37988892/odata-expand-and-select-queries-in-url

https://community.powerbi.com/t5/Desktop/OData-Feed-command-with-query-and-options-no-working/m-p/181822

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.

[Anonymous]

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: