Forum Discussion

anthonyg1986's avatar
anthonyg1986
Regular Visitor
4 years ago

Dates value changes after schedule refresh

Hi I have a table with one column which is a date value only and the latest date value is 9/11/22.  the date is linked to a number of other tables and runs as expected on my on prem  version of Power BI as well as when I publish the report to our server. 

The issue I have is when I run a schedule refresh on the server the latest date value changes to an earlier date 19/04/20. 

 

I have attempted to change the date format in power query with no luck.

Does anyone know what could be causing this? 

 

 

Refresh Schedule Error

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Most likely this is caused by your data (with a pinch of UTC salt). Remember that the Power BI service runs on UTC.

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi anthonyg1986 ,

     

    What are you using? Power BI Service or Power BI Report Server?

     

    It seams that you are using Power BI Service. If so, please consider Time Zone issue between local and Power BI Service as what lbendlin mentioned.

     


    Every Power BI Server (Where the Power BI Service lives) follows UTC (Coordinated Universal Time) for the server time. This is the universal time standard. You may have noticed that when you first publish your report the time stamp listed is correct it is only when you refresh that you see a difference. The reason for this is that Power BI refreshes time based on the localized time of the machine in which the report is refreshed on. So, refreshing on your local machine results in local time whereas refreshing on the services results in UTC.

     

    Reference: Power BI Service Time Differences and How to Fix It

     

    So you may do some operations to match the datetime between Power BI Desktop and Power BI Service. For details, please refer:

    Avoiding Issues When Generating Time/Date in Power BI - 3Cloud LLC. (3cloudsolutions.com);

    Resolving Timezone Issue on Power BI service – For Power BI.com (4pbi.com).

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi anthonyg1986 ,

     

    Another speculation:

     

    Do you mean that the date format changed from "m/dd/yy" or "d/mm/yy"  to  "yy/mm/dd"?

     

    If so, please change the data type in Power Query by "Using Locale...".

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.