Power Query change itself datetime

[Anonymous]

Hi,

I have problem with Postresql and Power Query.

In postgresql database i have data where format is timestamptz . Example: 2021-10-01 01:12:04.784 +0300

But when i load data to Power Query, then the value is 2021-09-30 22:12:05

Why PowerBI change the value and what to do, if i want excact date like in db?

I tried in SQL options:

date() does not work

:: timestamp does not work

AT TIME ZONE 'EET' does not work , because we have summer time and winter time

Some ideas?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try to change your data type to Date/Time/Timezone.

Best Regards,

Stephen Tao

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

[mahoneypat]

Look for the Changed Type step in your query where that happens (probably the first one), and change it to type text instead of type datetime in the Formula Bar (or select that step and then change the type of that column to Text and choose Replace in the popup).

Pat