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
swise001's avatar
swise001
Continued Contributor
5 years ago

michael_knight 

 

A few questions: 

 

Do these same inconsistencies show up in the Power BI Desktop file (prior to publishing to the service) - or only after connecting to the dataset after it has been published?

 

What means (formula, etc) did you use to strip away the time and keep the date? 


If you have access to the Power BI Desktop file where the conversion was done - this is where I would start - specifically at the step where the time was removed and date was kept.  

 

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

    • swise001's avatar
      swise001
      Continued Contributor
      5 years ago

      michael_knight 

       

      Is this repeatable with all dates?

       

      For example - if you create a second table containing dates - and publish it to the service - does the same -1 occur?

      This would be my next steps - try to isolate if the issue is only related to that single column's date structure - or if it is reproducible with other dates. 

       

      Is there anyway for you to share a snippet of the Power BI desktop file with that date column in place?