I built a report in the desktop version and all works fine. When I publish the report and refresh the data, I am getting the below error message. The column in question is a duration between 2 timestamps. I've tried it using the duration datatype and the decimal datatype.
Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Processing error: The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'prddwhschema XXXXXXXX' column 'inb_arvl_tm_diff'. The data provider was unable to convert the value '-00:10:00' from the source data type 'VT_BSTR' to the expected data type 'VT_CY'. Please check the column data types in the data model and data source and ensure that the data types are compatible. Table: prddwhschema XXXXXXXX.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 379be1bf-d9b6-461f-94d7-ccd9e4806f5a
Request ID: 414dd23c-f96f-ad07-199c-810ac54667bb
Time: 2018-11-09 14:36:49Z
Can you refresh report in power bi desktop? If there's no problem in power bi desktop, please update the data gateway to the lastest version and check if the issue can be solved.
Yes, the report refreshes in the desktop version. It still fails with the same error in the service, even after making sure the gateway was up to date. Thanks!