Type mismatch -Error when refreshing the published file

[Avivek]

Getting datatype mismatch error when refreshing the report on Power BI Service. The below is the error;

The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'Surgeon Sales' column 'NPI'. The data provider was unable to convert the value '<pii>Andre Nemecek</pii>' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible.

NPI is an id and its in the format Text.

Similar it is for order id and surgeon party id.

This view I had published earlier but it had 2 additional columns. Do I need to change the data type in the model or do i need to work in the back end.

[themistoklis · Accepted solution]

@Avivek 

PLease check the following 2 topics

https://community.powerbi.com/t5/Service/Dataset-failed-to-refresh-Unable-to-convert-a-value-to-the-...

https://community.powerbi.com/t5/Power-Query/The-following-system-error-occurred-Type-mismatch/td-p/...