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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ChahindaAlyy
Microsoft Employee
Microsoft Employee

time stamp on PBI connected to a live data source

hello Experts,

i have a pbi conntected to a live data sourve (Analysis services)

i want to know how to pput the time stamp on the report.

i received some workarounds, but they worked only for the offline data source

3 ACCEPTED SOLUTIONS
Brunner_BI
Super User
Super User

You want to put the timestamp of what in the report? Of the last refresh date, the last date in your dataset or the current time?

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

View solution in original post

If it is a direct query / live connection maybe you can just create a new Measure = NOW()

if you e.g. set up automatic page refresh this will always update

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

View solution in original post

Anonymous
Not applicable

Hi @ChahindaAlyy ,

Please note, When you create a report with Live Connection type, there is no data refresh , because when you open this type report, Power BI will get the latested data from data source to visualize.

If you want to show the timestamp of the last time you got the latest data, you could create a measure like this:

Time Stamp=NOW()

then add a card visual with this measure.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @ChahindaAlyy ,

Please note, When you create a report with Live Connection type, there is no data refresh , because when you open this type report, Power BI will get the latested data from data source to visualize.

If you want to show the timestamp of the last time you got the latest data, you could create a measure like this:

Time Stamp=NOW()

then add a card visual with this measure.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ChahindaAlyy
Microsoft Employee
Microsoft Employee

i want  the time stamp of the last refreshed date

If it is a direct query / live connection maybe you can just create a new Measure = NOW()

if you e.g. set up automatic page refresh this will always update

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog
Brunner_BI
Super User
Super User

You want to put the timestamp of what in the report? Of the last refresh date, the last date in your dataset or the current time?

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.