Hi All,
I have a web source that includes a date/time field in text form, like this: 10-15-2021 02:16:00. I have to do text substitution ( / for - ) before I can change the data type to date/time. However, when I publish to Power BI Service, it doesn't adjust for the different timezone the way other data sources do. I think this is because it is still stored originally as a text field. This creates problems when I try to do diff calculations on date/time fields across sources. I can get it to work on my laptop but it's off on PBI Service.
First, is my understanding of how the data is stored correct, and is there anything I can do about it, like force Power Query to store it as a true date/time field instead of text? I suspect I could with a custom connector, but that's a little over my head right now.
Thanks,
Bill
------------------------------
Bill Kellam
------------------------------