Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
epaez
New Member

Report Increases 5 hours to data when updated o refresh form web

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:

Screen Shot 06-13-20 at 10.44 AM.PNG

 

Web updated form desktop:

Screen Shot 06-13-20 at 10.46 AM.PNG

 

Web updated from Web:

Screen Shot 06-13-20 at 10.53 AM.PNG

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors