Roman Kobzarev on 22 Nov 2020 01:08:29
Hello. Power BI reporting lacks a significant feature.. Ability to recognize client's timezone or ability to set a default timezone. Any reports that rely on relative time/date are basically useless. We are in central time zone, every day at 6 pm, all reports that rely on relative Date filter, switch to next calendar date. I don't understand, how, this is not a standard feature??
- Comments (3)
RE: Timezone - cloud services
RE: Timezone - cloud services
Extending on this issue...
The below screenshot is from the Microsoft documentation regarding what time zone is used in a Dataflow refresh, depending on whether a scheduled refresh is setup. So many Power BI solutions do not use the scheduled refresh and rely on other methods to manage the refresh schedule, e.g. Power Automate. This means you're stuck with time zone issues.
[img]https://i.imgur.com/Us2odEV.png[/img]
To remedy this, and achieve what Roman is suggesting, why not allow for the 'default' time zone OUTSIDE of the scheduled refresh settings?
RE: Timezone - cloud services
Three years later and MSFT still pretending client time-zones are irrelevant 😟