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 ...
Need Help
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi GilbertQ,


        My locale settings for IE are set in Australia as well.

        I only experience this isue using Power BI service. The dates display correctly in Power BI desktop.

         

        I feel like it is some setting that needs to be done for Office 365 and/or Power BI, but i am not the administrator for my company.

         

        Any other ideas?

         

        Thanks

        Oneiricer