PostgreSQL refresh issue

[jakeryan56]

Hi team.

I am having this refresh failure on a PostgreSQL database through the gateway. It refreshes fine through desktop so I have no idea what table this relates to. There are a lot of tables with a lot of date/time fields so no idea where to even start..

Any ideas?

[Anonymous]

Hi  @jakeryan56 ,

According to the error message, it appears that you have entered the wrong date and time parameters.

The current power bi cannot recognize date and time values greater than 12/31/9999 or less than 1/1/1753. Please use a valid date and time value instead of the current value.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Look for date columns with nulls/BLANK() values