none
Issue with last refresh date time in Power BI reports RRS feed

  • Question

  • Hi All,

    I have Power BI report which shows last refresh datetime. I have this last refresh datetime as a custom column (DateTime.LocalNow()) and i have these reports published in PowerBI service. 

    1) I am in IST timezone but in PowerBI Service i wanted to show as in different timezone(say US & Canada). How can i achieve this?

    2) Whenever user visits the Embed URL. Is it possible to change the last refresh datetime based on the user location.?

    Couple of things I tried

    1. Changing the schedule refresh to US & Canada timezone still no luck
    2. Changed my local computer timezone -> refreshed in local computer -> published. When opened at first time date is in changed timezone. Next i performed refresh now in PowerBI service then again it got change to IST.

    You're kind suggestions are most welcome.

    Thursday, January 18, 2018 5:49 PM

Answers

  • Hi Murali,

    Refer the below link and follow the steps to dynamically convert/change the Time Zone based on the client access.

    https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

    Refer the below link, it will give you some idea about DAX timezone expressions.

    http://radacad.com/solving-dax-time-zone-issue-in-power-bi 



    Friday, January 19, 2018 9:20 AM

All replies

  • Hi Murali,

    Refer the below link and follow the steps to dynamically convert/change the Time Zone based on the client access.

    https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

    Refer the below link, it will give you some idea about DAX timezone expressions.

    http://radacad.com/solving-dax-time-zone-issue-in-power-bi 



    Friday, January 19, 2018 9:20 AM
  • Hey Murali,

    Here is the update, update your Power BI desktop to FEB-2018 version so that you can use UTCNOW() and UTCTODAY() functions. Refer the below URL to download to know about UTCNOW()/UTCTODAY()  functions

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/ 

    DAX has long supported the NOW() and TODAY() functions that return time and date in the timezone that the function's being used - so if a .pbix file is passed to someone in a different timezone they'll see different results. UTCNOW() and UTCTODAY() will always return the current time or date in UTC so you can guarantee consistent results wherever you are (and also when you upload the workbook to the Power BI service).


    Tuesday, February 6, 2018 7:32 AM