I have text column in this format - 2021-07-20T19:01:10.8986983Z
As you can see this is in UTC . In Power BI desktop when I mark the datatype of this column as datetime, its converted into my local time.
Now, When I publish this in service , this gets converted into UTC+3 (incidentally - my client is also in UTC+3) , this behavior is strange as Power BI service should be in UTC - This I have validated if I create a seprate column using datetime.localnow() and in desktop it shows my local time and in service it shows UTC.
Is the behavior of the text column in pbi service a bug or I am missing something here?
Thanks for your help.