Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Processing error trying to refresh dataset online

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

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi dsewall,

 

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.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors