Forum Discussion

MrMilk's avatar
MrMilk
Helper I
2 years ago
Solved

Working days error

I have a report with information on working days up to date and remaining days.
In Power BI Desktop, the information shows the correct number of days, but in the published report, with daily updates via personal gateway, it always shows one day less. What could it be?

Need Help

9 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Solution Supplier
    2 years ago

    Hey MrMilk 
    Here are few thing you need to check
    1)Check Timezone Settings - Ensure the timezone settings on your machine (where Power BI Desktop is running) and on the Power BI Service are synchronized

    2)Data Refresh Scheduling - Schedule your data refresh in Power BI Service to happen at an appropriate time.

    3) Clear Browser Cache - Sometimes clearing the browser cache can resolve display issues.

    4) Check Gateway Settings - Verify the system time and timezone where the gateway is installed.

     

    Thank you

  • MrMilk's avatar
    MrMilk
    Helper I
    2 years ago

    i use this to get the date for mu calendar table:

     

    let
    P_Today = DateTime.LocalNow(),

     

    in my computer is ok, if i publish is ok but on the next day on the daily update becames wrong

    • elitesmitpatel's avatar
      elitesmitpatel
      Solution Supplier
      2 years ago

      As you are using personal gateway maybe the Power Bi desktop report is not up to date when you perform daily update.

      as you said after publishing report values are matching but next day it is not matching after refresh.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MrMilk ,

    Based on the description, the power bi desktop calculate the local time. But, power bi service will return UTC time. Perhaps this is causing the one day short.

    Try to add the new column to calculate working days.

     

    Viewing the following documents to learn more information.

    Solved: Time Zone issue after publishing report - Microsoft Fabric Community

    Solved: DateTime in Published Report shows as UTC - Microsoft Fabric Community

     

    Best Regards,

    Wisdom Wu

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

  • MrMilk's avatar
    MrMilk
    Helper I
    2 years ago

    I found the problem... In the calendar table, I use the formula Date.DayOfWeek([Date]) to determine the day of the week, considering that 0 is Sunday. In Power BI Desktop it assumes this way, but in the published report it is different...0 is monday

     

    how can i fix it? anyone with this issue?