Enable a dynamic conversion from UTC to the local time

Category: azure stream analytics


imenmaiza on Mon, 16 Sep 2019 13:32:53


We are hoping that you might be able to help us with our problem,

We are working with streaming data generated by a sensor. We used IoT Hub as the input for our Stream Analytics job and Power BI as the output. Our problem is that we only get UTC Time in our streaming dashboard when we need to get dynamically the Local time. Now, we are using the DATEADD function to add the missing hours.

We look forward to hearing from you soon,

Thanks in advance for your help,

Best Regards


MartinJaffer-MSFT on Mon, 16 Sep 2019 22:13:22

Hello imenmaiza and thank you for your inquiry.  It sounds like you have a working solution.  Could you please elaborate what you would like done differently?

By 'get dynamically the Local time' do you mean that two people who look in Power BI will see their native time zones?

I found a discussion thread about that: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337


Please let me know if these do not help.

imenmaiza on Tue, 17 Sep 2019 08:28:16

Hello MartinJaffer ,

Thank you for your suggestion,

Yes, that's exactly what i mean, I want my customers 
 who look in Power BI streaming dashboard to see it by their native time zones.
unfortunately,  Since i am working with real-time streaming, I cannot use the Query Editor.( Modeling is not possible in streaming yet.). Also, i cannot go through  power BI settings because then i will identify just one time Zone while i want it to change dynamically.

I look forward to hearing from you soon,

Best Regards,

MartinJaffer-MSFT on Tue, 17 Sep 2019 22:49:40

Thank you for your polite manners imenmaiza.

I have done some reading and talked with my colleagues (I am not a Power BI expert).  Your ask appears to be a frequent request without a perfect solution at this time.

Your current approach of adding a column in Stream Analytics for each time zone seems to be the best approach.

There is another option, pushStreaming.  When using the push method of streaming, you can utilize more of Power BI's features; However, the visual will not update without pressing refresh button.

I recomend you request / upvote the feature in the feedback forums

There is one more option.  Show the time in a different way.  Assuming that your visual has time on one axis, and the range is fixed (always shows last 24 hours), why not replace the axis lables.  Instead of the tic marks saying "03:00 UTC", use "6 hours ago".  This bypasses timezones entirely, and only depends upon the latency of your data.

imenmaiza on Wed, 18 Sep 2019 08:53:01

Hello MartinJaffer ,

Thank you for your quick reply,

Your information was very helpful. Now I have a clearer idea about the limits of the product.

Best Regards,