Expand table field duplicate records issue

[Anonymous]

Hi,

I have an issue that i get data from dynamics 365 online CRM using Odata data source, the query in the calling api includes relationship between 2 entities, on expanding the field that returned from the 2nd entity, the records that has values are duplicated.

Note that, i get the data with the same api query using another tool, and it is correct, BUT on using the power bi i get this issue.

Also, i have changed the api query to be a relationship between 3 entities, But i have got an error on retrieving the data which is :-

( DataSource.Error: OData: The property '__DisplayName__' does not exist on type 'Microsoft.Dynamics.CRM.bookableresource'. Make sure to only use property names that are defined by the type or mark the type as open type. )

Please, any help ?

Thank you in advance. 

[v-lionel-msft]

Hi @Anonymous ,

Have you tried using the ‘Remove Duplicates’ feature to delete duplicate records?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.