Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
yoshihirok
Post Prodigy
Post Prodigy

TimeZone of Tile from Streaming dataset in Dashboard.

I want to set the TimeZone of Tile from Streaming dataset in Dashboard.

 

Now I use UTC Zone for Date by Microsoft Flow - utcnow() function.

and Store date is UTC like 2017-01-27T19:35:00.5402678Z.1.png

 and TimeZone of tile show JST +09:00 in Japan.

1.png

 

 How can I set TimeZone of tile in dashboard, and TimeZone of vizuals in Reports ?

 

Regards,

Yoshihiro Kawabata

 

 

1 ACCEPTED SOLUTION
v-caliao-msft
Employee
Employee

Hi@yoshihirok

 

I have create a sample streaming dataset in power BI services. And the time display in UTC time.
Capture.PNG

 

However, the timestamp display in chart as local time.
Capture1.PNGIf you need to change it to UTC time, you need to change you somputer time zone to UTC time zone.
Capture2.PNG

 

Regards,

Charlie Liao

View solution in original post

2 REPLIES 2
v-caliao-msft
Employee
Employee

Hi@yoshihirok

 

I have create a sample streaming dataset in power BI services. And the time display in UTC time.
Capture.PNG

 

However, the timestamp display in chart as local time.
Capture1.PNGIf you need to change it to UTC time, you need to change you somputer time zone to UTC time zone.
Capture2.PNG

 

Regards,

Charlie Liao

Hi @v-caliao-msft thank you for your check and your information.

 

I understand that the timestamp of Tile created from Streaming dataset show by Timezone of PC.

 

In visuals of reports, The timestamp of Streaming dataset is UTC time regardless Timezone of PC.

 

For we and our customers need JST+09 timezone of PC.

I add two values to a streaming dataset from Microsoft Flow.

UTC timestamp for Tile in Dashbord and,

JST timestamp for Visual in Report.

 

In Microsoft Flow

UTC timestampe created by "@utcnow()" in "Data Operations - Compose" action, like 2017-01-31T19:43:21.3010275Z

JST timestamp created by "@addhours(utcnow(),9)" in "Data Operations - Compose" action, like 2017-02-01T04:43:21.3322718Z

 

I hope any solution for one timestamp of streaming dataset both Tile and Visuals withing local timezone of PC.

 

Regards,

Yoshihiro Kawabata

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors