Forum Discussion

maryanncardenas's avatar
maryanncardenas
Regular Visitor
1 year ago
Solved

Change Date/Time Zone

I would like to ask for your help as I wanted to use different timezone for example use Dublin Time whenever my report refreshes. I tried using the measure "UTCNOW() + TIME(1,00,0)" - it does get the...
Need Help
Tutorial Requests
  • GrowthNatives's avatar
    GrowthNatives
    1 year ago

    hey maryanncardenas,

    To get report refresh time in Dublin time:

    1. Go to Power Query → New Blank Query
    2. Paste this code:
      • let

        utcNow = DateTimeZone.UtcNow(),

        dublinTime = DateTimeZone.SwitchZone(utcNow, 1) // Use 0 or 1 depending on DST

        in

        dublinTime
    3. Name it RefreshTimeDublin and load it to your model.

    *Note:

    • UTCNOW() in DAX shows current time, not refresh time.
    • Only Power Query captures the actual refresh timestamp.

    ⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
    💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
    🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

v-sdhruv's avatar
v-sdhruv
Icon for Community Support rankCommunity Support
1 year ago

Hi maryanncardenas ,

May I ask if you have resolved this issue? Were you able to convert your time to Dublin timezone?
You can follow the solution provided by danextian  and GrowthNatives  and these would help you to achieve your result.
If you are still not able to get the result, please consider sharing the error message or a sample data.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!