none
Enable a dynamic conversion from UTC to the local time RRS feed

  • Question

  • Hi,

    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

    Monday, September 16, 2019 1:32 PM

Answers

  • 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.

    Tuesday, September 17, 2019 10:49 PM
    Moderator

All replies

  • 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

    https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

    Please let me know if these do not help.


    Monday, September 16, 2019 10:13 PM
    Moderator
  • 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,


    • Edited by imenmaiza Tuesday, September 17, 2019 8:59 AM
    Tuesday, September 17, 2019 8:28 AM
  • 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.

    Tuesday, September 17, 2019 10:49 PM
    Moderator
  • 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,




    • Edited by imenmaiza Wednesday, September 18, 2019 8:54 AM
    Wednesday, September 18, 2019 8:53 AM