Data Sync timestamp on the Report!

[sandeep540]

I want to show timestamp as to when the last time data was synced with PowerBi cloud  on the Report ! Is there any way to do it?

One way is the get the time from DB itself like

MS SQL - select cast(AttDate as time) [time] from yourtable

ORACLE - select sysdate from dual

and then show it? but does Powerbi.com has this feature natively?

[ankitpatira]

@sandeep540

In power bi service, go to your dashboard, click on three dots, settings and you will find an option to show last refreshed time on the dashboard tile. However that time is the time tile has been refreshed from your dataset (which usually happens every 15 minutes). To show time that your dataset has been refreshed on your report using NOW, TODAY functions are your best bet. You can also see previous refresh times by going to dataset, schedule refresh history but unfortunately you can't set to be shown in report.

[SamLester]

You can view the last refresh date of the data source that the visuals/dashboard are built on, but I don't think it is supported as a built-in field, as in SSRS. There are a few options listed in the thread below. I like the idea of including a field that contains the current date/time (NOW(), GETDATE(), etc. depending on your source) and incuding it in the report. When the data is refreshed, this value will reflect that time and you can use it in the report.

http://community.powerbi.com/t5/Service/last-time-refresh/td-p/7200

Thanks,
Sam Lester (MSFT)