Not a legal OleAut Date Error Message - Cannot Refresh

[mj1996]

I have seen other threads about this issue, but my report actually does require dates with the years 2049-2099. Is there a workaround for this? 

The report works fine on Desktop but not Service. 

[v-kelly-msft]

Hi @mj1996 ，

Have you checked the post below?

https://community.powerbi.com/t5/Report-Server/not-a-legal-oleaut-date-cannot-refresh/m-p/539658

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mj1996]

Thanks for sharing but yes I have. 

My dates range from 2019 to 2110 but they're not necessarily errors and are needed for the report. 

[v-kelly-msft]

Hi @mj1996 ,

Just now I tested the issue you said,BUT it works fine here,as is shown below:

So would you pls check whether the date column has all been set to date type?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mj1996]

Thanks for your reply! You're right, these don't seem to be the issue as I've tried to refresh with them excluded. 

The dates are also all set to Date field type. Could there be another cause for this error message?

[v-kelly-msft]

Hi @mj1996 ,

The error means the data has a problem,so would you pls check recheck the date column in desktop,does all the related rows set correctly?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!