How can I convert the datetime of streaming dataset to local time in Q&A X-axis ?

[yoshihirok]

I want to show the datetime data of streaming dataset to local time in Q&A X-axis.

Streaming dataset:

"DateTime" is DateTime type

"Processor time" is Number type.

"Computer" is String type.

"DateTime" value build by PowerShell's Get-Date which have Time zone information.

My Time zone is +09:00 on Japan.

"ProcessorTime" value build by Performance Counter's % Processor Timer.

"Computer" value build by my computer name.

The visual by Q&A: "show avg of processor time by date within last 5 minutes group computer "

The tile x-axis's DateTime Timezone is GMT.

Just like 09:06 at 18:06 on Japan.

The visual by Add a custom string tile which "axis" is "DateTime", "values" is "ProcessorTime".

The tile x-axis's DateTime Timezone is JST.

Just like 18:06 at 18:06 on Japan.

So, I want to change X-axis timezone from GMT to JST in Q&A visual.

Regards,

Yoshihiro Kawabata

[v-shex-msft]

Hi @yoshihirok,

Did you use the azure steam analytics to output the data? If it is a case, you can use dateadd function to modify query to format the datetime to your timezone.

Sample:

DATEADD(hour,2,EntryTime)

Reference links:

Stream Analytics Query Language Reference

Date and Time Functions (Azure Stream Analytics) 

DATEADD (Azure Stream Analytics)

Regards,
Xiaoxin Sheng

[yoshihirok]

Hi, @v-shex-msft thank you for your information about Azure Stream Analytics, and DATEADD function.

Yes, by using Azure Stream Analytics, solve this issue.

Now, I want to know this without Azure Stream Analytics, no-additional-cost, no-additional-learning, no-additional-managing to convert the datatime to user's timezone.

Power BI's streaming dataset feature is very cost-effective service to visualize realtime data.

I'm looking for more effective senario of this feature.

Regards,

Yoshihiro Kawabata.

[v-shex-msft]

Hi @yoshihirok,

Ok, I will keep researching for your requirement.

Regards,

Xiaoxin Sheng

[AlejoSQL]

In ASA, there is a known issue in which ASA does the internal conversion from ISO8601 to UTC without any option to alter that behaviour. (effectively losing the timezone offset)

In our case, we had to add additional columns and perform all the calculations to get back to the local timezone

Alejandro Leguizamo

@ @witter: @AlejoSQL