cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CloudMonkey Post Patron
Post Patron

Database refresh timestamp

Hi,

 

I'm looking to have a parameter that tells me the date/time that my database was refreshed. If I just create a calculated column with the NOW() function would that work? Would anything cause that value to change other than me pressing the data "Refresh" button?

 

Thanks,

 

CM

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User II
Super User II

Re: Database refresh timestamp

Hi @CloudMonkey,

 

You can get your answer from the below mentioned URL:

 

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

 

Please mark this as a Solution so it may help others!

  

View solution in original post

Thim Resolver V
Resolver V

Re: Database refresh timestamp

Two answers.

 

First answer:

You can make it as a column first on your data table. Then it should only be updated, when the data is updated. But you do need to offset it if you want to show the correct time online.

For my country it is NOW() + (02/24)

Reason for the offset, is the Now formula responds to were the actual data is being held, and not from the viewers, or yours position.

But if your country have daylight save time, then you will need to change this each time the time difference changes.

 

Second Answer: 

If it is to show online for the viewers, i would suggest, they switch over to the new Look, as this actualy shows the update time on the top. (Just noticed this today)

 

Hope this will help.

Time Stamp.PNG

View solution in original post

2 REPLIES 2
Super User II
Super User II

Re: Database refresh timestamp

Hi @CloudMonkey,

 

You can get your answer from the below mentioned URL:

 

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

 

Please mark this as a Solution so it may help others!

  

View solution in original post

Thim Resolver V
Resolver V

Re: Database refresh timestamp

Two answers.

 

First answer:

You can make it as a column first on your data table. Then it should only be updated, when the data is updated. But you do need to offset it if you want to show the correct time online.

For my country it is NOW() + (02/24)

Reason for the offset, is the Now formula responds to were the actual data is being held, and not from the viewers, or yours position.

But if your country have daylight save time, then you will need to change this each time the time difference changes.

 

Second Answer: 

If it is to show online for the viewers, i would suggest, they switch over to the new Look, as this actualy shows the update time on the top. (Just noticed this today)

 

Hope this will help.

Time Stamp.PNG

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors