cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Display Latest Refresh Time in Local Time in PowerBI Embedded based on user's region

Hi techies,

 

I would like to create a simple card visual and place it into my report to show the last refreshed time of the dataset.

My dataset has a fixed automatic schedule refresh in PowerBI Service and I want my report to display this information for my end-users. Since all my users are sitting at anywhere in the world and there could be timezone issues.

What I understood so far is that PowerBI Desktop displays "local time", while PowerBI Service / PowerBI Embedded displays "UTC time". I want my users to see the last refreshed time based on their own timezone (eg. Users sitting in UK will see UKT in PowerBI Emdedded. Users sitting in New Zealand will see NZT in PowerBI Embedded.....etc).

Already tried to google around and did some tests on my own but not 100% successful.

Anyone can suggest the best and easiest way to do this?

 

Best regards,

Emily

 

2 REPLIES 2
Community Support
Community Support

Hi @emilypoon1 ,

 

Currently, Power BI doesn't support to automatically identify the time zone of the browser. 

You can post your idea on Power BI Ideas forum. It is a place for customers to provide feedback about Power BI.

 

In addition, you can get one workaround from this post: Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com).

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Super User IV
Super User IV

@emilypoon1 , refer if this can help

https://stackoverflow.com/questions/61111965/how-to-force-power-bi-service-to-use-local-timezone



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors