Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Service Dates

 Hi Power BI,

 

My Power BI desktop has been correctly configured to my locale (Australia).

However any reports that i publish into Power BI Service have US style dates, and the timings have been coverted to US.

 

e.g. I check my usage stats on the reports i built. I know that i only look at my reports during business hours, but the usage statistics says i logged in on Sunday to view. This is not correct but i am assuming because it is in "US-time".

 

Does anyone know how i can fix the US times on Power BI service?? (i.e. the web interface)?

 

Thanks

Oneiricer

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there

    If your PBIX file is using the DAX functions of NOW() or TODAY() as well as any of the Power Query Functions these will be default always log it as UTC.

    What I suggest to people is if the dates are set to UTC (Which are the timezone for all Power BI Servers) I suggests adding the required HOURS to the dataset.

    Here is my blog post explaining how all the servers are, as well as a means to change the Time: https://www.fourmoo.com/2017/10/03/power-bi-did-you-know-all-power-bi-services-servers-are-in-utc-now-how-to-handle-it-for-dates-times/
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks. I do use today() functions in DAX so this explains part of the problem.

       

      The other problem is that i have slicers that allow the user to control the date range. These are also changed to US styled dates. This is not something i can use DAX to change as these use the slicer functionality out of the box.


      Do you know of a solution to this?

      Many thanks

      Oneiricer

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago

        Hi Anonymous

         

        That is really interesting when I look at my dates in the Power BI Service, I have them as shown below.

         

         

        I do have a Date table setup.

        I also ensured that I have got my Locale Settings, setup via Internet Explorer (Yes I know!) are set with the default being Australia.


        If that does not work let me know.