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
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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        hi michael_knight - thee report has some customer data - I shall mock up something and share it with you shortly. Thanks!