Not a legal OleAut Date : REFRESH ERROR

[thampton]

Hello - i have a report on PBI desktop that refreshes fine, but when I refresh on PBI service, it throws the error below. I checked the table that is erroring out and all date columns have valid dates. 

Data source errorNot a legal OleAut date.. The exception was raised by the IDataReader interface.

Any ideas?

[v-shex-msft · Accepted solution]

Hi @thampton,

I'd like to suggest you refer to following link which has same issue, it seems like your table contains invalid date value some it throw this error when you use it on service side:

not a legal oleaut date - cannot refresh

Regards,

Xiaoxin Sheng