Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

KKR_ISED

Postgres connector imports timestamptz as Date/Time instead of Date/Time/Timezone

Submitted by on ‎03-08-2023 08:35 AM

PostgreSQL has two timestamp types, timestamp and timestamptz, the latter of which includes time zone information. However, the Postgres connector included with Power BI imports both types as Date/Time values instead of mapping timestamptz to Date/Time/Time Zone, resulting in a loss of time zone information. This bug is reproducible in Import and Direct Query modes.

 

Power BI version: 2.114.864.0 64-bit (February, 2023)

PostgreSQL version: 13.7

Status: Investigating
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎03-08-2023 09:41 PM

Hi @KKR_ISED ,

 

Does this problem only occur in the current version? Has this problem occurred in the past?
Would it be useful to roll back to a previous version as a temporary workaround?

 

Best regards.
Community Support Team_ Caitlyn

 

 

KKR_ISED
Regular Visitor
‎03-09-2023 05:07 AM

Hi @Anonymous, this problem occurs in the previous version of PowerBI as well, so a temporary rollback would not help. 

Anonymous
Not applicable
‎03-20-2023 01:13 PM

I have a same problem. Did anyone have suggestions how to handle it?

Idea Statuses