Week Beginning day changes when I refresh a report in PBI service

[osabhaois]

Hi All

I have a report where the week beginning day is set to Monday.

I do this in a calender table.

When I publish the report to PBI service, after the first scheduled refresh the week beginning day changes from Monday to Sunday in the online version of the report.

I have a slicer that slices by week based on the week beginning date and it changes from the Monday to the Sunday for a given week.

Does anyone know if there is a setting in PBI service that is over ridding my PBI desktop week beginning setting.

thanks

[osabhaois]

Hi

I am working in GMT.

So my week beiginning in PBI desktop is Monday.

I have a date column in my calender tablw which I duplicate and use transform data -> transform -> Date -> Week -> Start of Week

This gives me a week start date of Monday.

Why does the Monday start date chenge to Sunday when I publish to PBI service.

thanks

James

[v-kelly-msft]

Hi  @osabhaois ,

Check the similar thread below:

https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/td-p/153663

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[lbendlin]

The Power BI service is running on UTC.  Depending on where you are in the world that can result in the day shift you observed.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi