Skip to main content

Power BI

New

Bug on Date.IsInPreviousWeek(dateTime) : timezone argument required

Vote (1) Share
Jerome's profile image

Jerome on 04 Jun 2018 21:26:26

Date.IsInPreviousWeek(dateTime) outcome is unpreditable when executed on a scheduled refresh on PowerBI service on Monday morning.

The outcome depends on the timezone where the function is executed which is different from the timezone defined at during the scheduling of the refresh.

The timezone used as a reference should be specified as a mandatory argument, or the function should use the timezone of the poweBI service.