Why do my date fields in Paxata change when I connect to vizualization tool?
My answersets in Paxata contain date fields in the standard Paxata format (2019-06-30T00:00:00.000Z) but when I connect to the answerset in another tool (Power BI), that same date field appears as "6/29/2019 8:00:00 PM". Similarly, 2019-012-11T00:00:00.000Z becomes "12/11/2019 7:00:00 PM". All my dates seem to have a 5hr discrepancy during Standard Time or a 4hr discrepancy during Daylight Savings Time (I am in ET). Why is this happening, and short of changing the format of each date field individually, how can I keep this from happening?
Paxata attempts to internally manage dates in GMT/UTC. When you export your data from Paxata into another system, that system may interpret those timestamps in the timezone configured for that system/server. This appears to be what happens with Power BI.