Hi all,
We are bringing GIS tables into Power BI through JSON queries. The date fields, both ESRI generated (such as created date, edit date) and created by us (Install Date, Lining Date) are all coming through as strings. I've tried several dax statements to convert them, but not luck yet. Does anyone who works in the space regularly have any ideas? See attachments for examples of what is coming through. The fields are formatted as dates in the ESRI feature service.