cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phyten
Helper I
Helper I

Visual element with timestamp for last data update

I have a connection to salesforce objects. How do I get a new visual element within my report which shows me the timestamp of the last data update. 

sync.jpg

something like this. 

 

I don't get the information from the requests data. Is there a way to get this information from powerbi itself.

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@phyten

 

Within Power BI Desktop, you can add another Power Query dataset to display the current date each time we refresh the report. For more details, please see: Display Last Refreshed Date in Power BI.

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft
Microsoft

@phyten

 

Within Power BI Desktop, you can add another Power Query dataset to display the current date each time we refresh the report. For more details, please see: Display Last Refreshed Date in Power BI.

 

Regards,

View solution in original post

austinsense
Impactful Individual
Impactful Individual

I don't think there's a way to grab the last refresh date, but you can grab the most recent date from one of your data tables and display that ...

 

MAXDATE = CALCULATE(MAX(Transactions[Date]), ALL(Transactions))

Not perfect but it works really well in showing users how up-to-date the data is

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.