Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community,
I have a Power BI with DataOrigin in a PosgreSQL database in Azure. The data contains dateTime fields that I use it for graph in the report the data per day.
When in publish from my Desktop to Power BI web, all runs ok, and I can se the same report done in my Desktop in the Web.
But when I activate the automatic schedule refresh, or when I refresh the dataset from the web, or when I use Power Automate (Flow) for refresh the dataset, the report increases 5 hours in all the data. So, if for example a register has a time like 10:31 am, the report now shows 15:31 pm, that means that all the registers with dateTime after 7:00 pm, appears in the reports as tomorrow data when the automatic refresh of dataset is used.
I try to change the Time zone in the Automatic Refresh schedule setup in the Web but does not matter what time select, always increases 5 hours to data. My TimeZone is GMT-5..
Somebody knows how to solve it?
Thanks in advance,
Desktop:
Web updated form desktop:
Web updated from Web:
Solved! Go to Solution.
Yes, the Power BI service runs on UTC. You need to do local time zone conversions yourself if needed.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Yes, the Power BI service runs on UTC. You need to do local time zone conversions yourself if needed.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi