Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
5 years ago

Time/Date Problem when publishing to Power BI Service

Hi,   I've got a problem with my Date/Time when publishing to PBI Service   This dataset I've got is used to show the completions in the business. I have a Completion Date and I converted it from...
Need Help
Tips and Tricks
michael_knight's avatar
michael_knight
Post Prodigy
5 years ago

Hi swise001 

 

The screenshot I posted is from Power BI Desktop, and it works fine in that and I'm very happy with the numbers. Once I upload it to the Power BI service, it -1 day for every single record

 

I don't use a formula, I change the datatype with the drop down option in Desktop

 

I use the USERELATIONSHIP function in order to connect the completion date to the date table

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi michael_knight, can you confirm if you are using  PRO license or a Premium license? 

Also are you using any TODAY() or NOW() in DAX?

 

I have experienced that these above functions will return the Power BI service server time when used - and this causes issues in reports. I had to implement some logic to calculate back to US timezone to ensure my report logic works as expected. 

 

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

  • michael_knight's avatar
    michael_knight
    Post Prodigy
    5 years ago

    Where abouts do you input that formula, Anonymous ? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi michael_knight  - I have used that formula in a while I was creating a DAX measures for one my report KPIs. 

       

      Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

      • michael_knight's avatar
        michael_knight
        Post Prodigy
        5 years ago

        Can you post a PBIX file with it included? I'm interested to see how it works Anonymous 

         

        I tried creating another column which +1 days and that worked until it hit December when it stopped -1 to all of my dates. Really puzzling