cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsewall Frequent Visitor
Frequent Visitor

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
Community Support Team
Community Support Team

Re: Processing error trying to refresh dataset online

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

Highlighted
dsewall Frequent Visitor
Frequent Visitor

Re: Processing error trying to refresh dataset online

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 300 members 3,349 guests