How to set up time zone based on countries and show their local time when RLS is passed to a contrac

[Dharmendharan_L]

I have a contract table, it has contract names and there are countries based on contract. I have country table and their time zone code EX: '+05:30'. Contract table is connected to fact tables . RLS is set up for contract ID, My requirement is to set up a visual showing last refresh date and time, based on different region. Example if contract ID = 4, for this contract Country = Germany. Also schedule refresh is set up for 8 times a day. The Last refresh in the report should dynamically change and display last refreshed local time based on country. Note: Should consider Day light saving time.

[v-yueyunzh-msft · Accepted solution]

Hi , @Dharmendharan_L 

According to your description, you want to get the refresh time for different people and show the according to the timezone in their side .

For your need , i think you can add a date time in your Power Query and when you refresh , this date time will be changed and you can use it show the datetime you need in your report.

For the date time in Power Query , you can add a UTC+0 date time in it :

DateTimeZone.UtcNow - PowerQuery M | Microsoft Learn

How to Show Last Refresh Date in Power BI / Blogs / Perficient

And then you can create a measure to show the different datetime for different user in your logic . You can try to use the USERNAME() and USERPRINCIPLENAME() to get the current user in Power BI Service.

USERNAME function (DAX) - DAX | Microsoft Learn

And you can also refer to how to get the Daylight Savings Time in Dax i hope it can help you:
DAX Measure to Dynamically Offset Datetime Based on Daylight Savings Time | Sandeep Pawar (pawarbi.g...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly