cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarioCadena
Helper II
Helper II

Report Last Refreshed Date and Time

Hi,

 

I added the last refresh date of the report using the following formula in power query.

= DateTime.LocalNow()

 

In Power BI Desktop works well

 

MarioCadena_0-1610339436738.png

But in power Bi Services format and time are not right; I tried on Chrome and Explorer the same result.

MarioCadena_1-1610339487643.png

 

Do you have any recommendations?

 

Regards,

 

Mario

 

 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Don'@MarioCadena,


This is not directly related to which browser it opens. Depending on your description, the first thing you need to understand is that this formula returns a DateTime value set to the current date and time in the system. So on the desktop it returns the system time, but in the service, PowerBI will follow the current position of the server, it will return to the last update time. I tried to use the UTCNOW() function and got the same time both on the desktop and in the service. You'd better learn about this feature.

v-henryk-mstf_0-1610502111757.png


This is a related blog and a similar post, it can be used as a reference.

Solve the DAX time zone problem in Power BI - RADACAD
Fixed: Last Time Update - Microsoft Power BI Community


If the problem is not yet resolved, provide detailed information about the error and let me know immediately, waiting for your response.


Best regards
Henry


If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Don'@MarioCadena,


This is not directly related to which browser it opens. Depending on your description, the first thing you need to understand is that this formula returns a DateTime value set to the current date and time in the system. So on the desktop it returns the system time, but in the service, PowerBI will follow the current position of the server, it will return to the last update time. I tried to use the UTCNOW() function and got the same time both on the desktop and in the service. You'd better learn about this feature.

v-henryk-mstf_0-1610502111757.png


This is a related blog and a similar post, it can be used as a reference.

Solve the DAX time zone problem in Power BI - RADACAD
Fixed: Last Time Update - Microsoft Power BI Community


If the problem is not yet resolved, provide detailed information about the error and let me know immediately, waiting for your response.


Best regards
Henry


If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

Singaravelu_R
Resolver II
Resolver II

Hi,

 

Please try below measure

Date &Time = UTCNOW()

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.