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 (5)
RE: Timezone - cloud services
Yeah Microsoft, what are you doing, this is like basics. Let me set the TimeOne of my tenancy for Fabric and Power BI.
RE: Timezone - cloud services
getTimezoneOffset() method in JavaScript does take daylight saving time (DST) into account, and would be a easy fix for Microsoft to return the same way as the USERPRINCIPALNAME() do.Then it also would be easy for all Power Bi report developers to adjust time without doing complex api calls towards other web servers to get this done.Also strange thing that Microsoft is ignoring this question.
RE: Timezone - cloud services
image
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 😟