Incorrect datetime on Power BI reports

[cnwakanma]

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?

[cnwakanma]

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]

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.