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
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.