The following system error occurred: Type mismatch

[Salzinho]

Hello,

I get following error, when trying to update data via the web version. It is wrking with the desktp version:

The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table '<pii>File</pii>' column '<pii>Cal. year / month.Cal. year / month Level 01</pii>'. The data provider was unable to convert the value '<pii></pii>' from the source data type 'VT_BSTR' to the expected data type 'VT_DATE'. Please check the column data types in the data model and data source and ensure that the data types are compatible.

Do you have any idea how t fix this? Thanks

[v-rongtiep-msft · Accepted solution]

Hi @Salzinho ,

This error could be an issue with your M script within your Power BI Desktop file.

Why refresh works in Power BI Desktop but not in Service, It may for the date conversions are handled differently in the Power BI Service, and the Power BI Service is not tolerant of an invalid date. 

As a temperary solution, you could refresh the PBIX in Desktop and re-upload the file to the Service.

Or you could check the column data types in the data model and data source and ensure that the data types are compatible. 

I have also found a similar post, please refer to it to see if it helps you.

Type mismatch - Unable to convert a value to the data type requested 

• right-click the colum and use Replace Values. In Query Editor

If there still errors, please provide a screenshot about the error and more details.

Best Regards

Community Support Team _ Polly

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

[Salzinho]

Hi,

thanks for help. Indeed the data type imported from tha data model was incrrect and therefore not compatible. Thanks for your help.

Best regards

Salzinho

[ibarrau]

Hi. It looks like your date format can't be recognize by Power Bi as regular date. Be sure you have the correct values for that. It looks like yyyy/mm/dd. If you are confidente on the values you are adding as years, months or days, you can change type using locale (specific date formats).

More info: https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query

That way it might identify the format you want for date, because right now it is failing when converting to date.

I hope that make sense.

[Salzinho]

Hi,

thanks for suggestion. This is unfortunately not the solution.

Best regards