Forum Discussion

cnwakanma's avatar
cnwakanma
Frequent Visitor
10 years ago

Incorrect datetime on Power BI reports

Hi all

I'm working on a real time dashboard from event hub data. I'm using stream analytics to aggregate and push output to power bi dashboard. I've hit a problem where the time values displayed on power bi reports have wrong values. The data is sent to event hub in UTC time format WITH time offset. The local time zone is MST while the time displayed on reports are +0500 hrs. Any ides on what could be wrong?

Need Help
Tips and Tricks

2 Replies

  • cnwakanma's avatar
    cnwakanma
    Frequent Visitor
    10 years ago

    For others who may experience thes same issue, i found that stream Analytics does not support Time zone offset and only operates in UTC time.

    • jac_rod's avatar
      jac_rod
      Regular Visitor
      10 years ago

      Hey CN,

       

      Have you figured out a work around here?  Stream Analytics integrations is really nice, but the time zone issue is causing problems with the Q&A questions I'm using to populate my dashboard.