undefined

[Prakul]

Hi Everyone, 

So I work for a company in Winnipeg (Canada). I wanted to show the last refreshed date in my report. I used http://worldtimeapi.org/pages/examples to get the time for America/Winnipeg which seems to be correct. On Power BI desktop, this works properly but when I upload this to service, the time changes for some reason. I am not sure what could be the problem since I am not using local time and using this API instead. 

Also, After updating the report in Power BI service. I dowloaded the report (after time changed) from the service to see what does the Power Query show. Power Query is showing correct time, but the data view is showing different time (which is same as when Service). Any Idea why this is happening?

Time in Power Query: datetime 2/2/2024 11:44:40 AM

Time in Dataview: datetime 2/2/2024 5:22:51 PM

Thanks

[Anonymous · Accepted solution]

Hi @Prakul ,

If I understand correctly, the issue is that you want to show the last refreshed date in the report. Please try the following methods and check if they can solve your problem:

1.Check the refresh regional settings in the Power BI service.

2.Select Options, turn off the auto date/time feature.

3.Create a column in Power query that converts time to the desired time.

= DatetimezoneDateTimeZone.SwitchZone

4.Go to File > Options. Select Regional settings and change the locale for import.

Best Regards,

Wisdom Wu

[Idrissshatila]

Hello @Prakul ,

check this out https://youtu.be/eH9dHfNG8kg?si=CtFiB3sbNrQVnWdP

[audreygerred]

Power BI service runs on UTC timezone. You can try some methods from the following link: Solving DAX Time Zone Issue in Power BI - RADACAD