suddenly get error when refreshing dataset

[remo_sen]

Hi,

Starting today I began getting errors when refreshing the dataset through powerbi web. The refresh works without any issues on PowerBI desktop. I was able to refresh the data in powerbi web without any issues this morning. Here are the details: 

Last refresh failed: Tue May 29 2018 19:10:10 GMT+0200 (W. Europe Summer Time) 
CancLast refresh failed: Tue May 29 2018 19:10:10 GMT+0200 (W. Europe Summer Time)
Cancellation occurred when sending or receiving a request.Hide details
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 8908f024-ce67-4315-8474-3f8a66daade0
Request ID: fbeec21b-f8b2-f204-2162-1d1d93d3df26
Time: 2018-05-29 17:10:10Z

Data comes from 1 single PostgreSQL database, the amount of data is minimal. My .pbix files are around 10-15MB. 

I would glaldy appreciate some help. We are a small company running PowerBI Pro for trial right now, to see how well it works. 

Thank you! 

[v-qiuyu-msft]

Hi @remo_sen,

From internal telemetry, I found two exceptions:

1. Column 'Team' in table 'public ordering_order' with error "DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

2. Column 'Base Cost DACH' in table 'Financials Daily' with error "Not a legal OleAut date.. The exception was raised by the IDataReader interface."

I would suggest you open the report in Power BI desktop, and check above tables. 

Best Regards,
Qiuyun Yu