The Date operation failed

[sontt]

Hello,

I added the datasource to the enterprise gateway then go to the settings of the dataset and change from personal gateway to enterprise gateway.

But I got this problem when i try refresh the data.

It is throwing this error:

Underlying error code:	-2147467259
Underlying error message:	The Date operation failed because the resulting value falls outside the range of allowed values.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	a3e40c80-e5c1-406f-9ab5-9a38d68acc96
Request ID:	960bc35c-a71c-ec11-3a32-248d70fb74b0
Time:	2017-06-20 04:16:09Z

How can I fix it?

Thanks !

[v-qiuyu-msft]

Hi @sontt,

In your scenario, please download the report and refresh it in desktop. Check if any date value out of the range. When the refresh successfully in desktop, then republish to service.

When you use the data gateway to refresh the dataset, please try to always run the latest data gateway version.  

Best Regards,
Qiuyun Yu