Forum Discussion

ryan0585's avatar
ryan0585
Advocate II
7 years ago

PostgreSQL Date Differences

I have an unusual issue I've run into.  We have a front-end client where our users enter dates in a datetime format.  The application sits on top of a PostgreSQL database, which I'm able to connect t...
Need Help
ryan0585's avatar
ryan0585
Advocate II
7 years ago

Thanks Lin.  We're working through a migration this week, so (hopefully tomorrow) I'll provide a trimmed down file attempting to illustrate the issue.  That said, truly seeing what's going on requires a PostgreSQL editor to compare the output side-by-side.

 

In the meantime, I got around the issue by getting the month name from the date using Power Query / M, but I know that isn't always an option for folks.

 

Will upload a file shortly.

 

Thank you.

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, ryan0585 

Could you please tell me if your problem has been solved? please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.

 

Best Regards,

Lin

 

  • ryan0585's avatar
    ryan0585
    Advocate II
    7 years ago

    Hi Lin, sorry but the original reply was not a solution so I will not mark it as such.  I have not had time to generate a sample dataset that does not contain PII.  The issue I'm experiencing is specific to PostgreSQL data sources, so unless there's someone with access to PostgreSQL, it's going to be difficult for anyone to help me here.

     

    My workaround was to do the date modification work I needed to do in Power Query instead of PostgreSQL.  Still, the underlying question about PostgreSQL date interpretation vs. Power BI remains, if for nothing else, curiosity on my end.