Working days error

[MrMilk]

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?

[MrMilk]

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?

[Anonymous · Accepted solution]

Hi @MrMilk ,

Based on the description, try to use the following formula.

Date.DayOfWeek([Date], Day.Sunday)

You can also view the following documents to learn more information.

Date.DayOfWeek - PowerQuery M | Microsoft Learn

WEEKDAY function (DAX) - DAX | Microsoft Learn

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]

my timezone is UTC

[Anonymous]

Hi @MrMilk ,

Try to verify the refresh history to see if having any issue and verify data source credentials.

Viewing the following documents to learn more information.

Troubleshoot Power BI gateway (personal mode) - Power BI | Microsoft Learn

Use a personal gateway in Power BI - Power BI | Microsoft Learn

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.

[Anonymous]

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]

How can i fix it?

[MrMilk]

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]

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.

[elitesmitpatel]

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