MS Dynamics 365 Office Add-in: Error refreshing data Details: Incompatible type kinds were found.

[saravanaprakash87]

Hello, In one of my custom forms, I use "Open in Excel" to edit and publish the content of a form.  I'm receiving the below error when I opened in Excel plugin. 

I even tried to open in the browser. But stil the same error.

It was working fine when I created the entity some time ago. But all of sudden I'm getting this issue. I did not make any changes the tables associated with the entity. 
DMF import/export seems to work fine. I only face issue for this entity; all other custom and native entities are just fine when opened in excel. Can someone help me figure out what's going on?

[xuzhg]

Did you update any OData lib dependency?
Do you mind to book some time (Please share a link to [email protected]) so we can debug together remotely?

[v-sgopalsamy]

Hi @xuzhg -

I found the root cause of the issue. The reason the excel plugin of the entity fails only in the lower environment is due to another entity which is deployed recently. The public collection name of the older entity conflicts with the meta data of the new entity. In the new entity, one of the fields is an Enum. The Enum property of the new entity DataSource and the public collection name of the older entity happened to be same. So, when an OData call for the older entity is made with the collection name (which is in conflict the new entity's metadata), it failed and returned an error.

Now I changed the Enum property for the field of the entity DataSource. It works fine now. I confirmed this by changing the collection name of the older entity and it worked fine.

Thanks for your support.