The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a report where I need to use the local time (UK) to calculate how long items have been overdue in minutes.
When I use 'NOW()', PowerBi desktop is one hour ahead of the same report when it is published to the PowerBi service.
e.g. desktop will be '18:06', and the web version is '17:06'.
Is there a solution to this?
e.g.
in PowerBi desktop
same report in the browser