Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.