Unable to load table into Power BI from Dynamics 365

[PalakA]

When loading data from Odata into Power BI, it get this error on a few tables: "DataSource.Error: OData: Cannot convert the literal '12659684' to the expected type 'Edm.String'." The rest of the tables are loading as planned. I am loading CRM data from Web API Url. Below error comes from Navigator window itself.

PFB screenshots-

Any suggestion would be much appreciated.

Thanks in advance.

[v-xicai]

Hi  @PalakA  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @PalakA ,

This may be a data type convert issue. You might find the field with the numeric value, try to format it to Text data type, or add  double quotes " " for the numeric value like 12659684 in the original data source.

Best Regards,

Amy 

Community Support Team _ Amy

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