Forum Discussion
Sqldatetime overlfow
Every now and then scheduled report refreshes fail with the following error: PBRS Refresh Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. It looks ...
ABloemberg , do you have any date beyond that range. or is there a format issue ?
Please check at source any date beyond the range. Also open power query and check for error row
amitchandak
It looks like an internal PowerBI server issue. All reloads for a specific report fail until a download/Upload of the pbix is done, without touching the pbix file inbetween.
Also a local refresh works without a problem, so it is not an incorrect date in the dataset