how to show the last schedued update time in the power BI report

[Ramendra]

I've set the scheduled refresh 4 times a day for the Power BI dataset.

I want to add the date and time in the card view in the dashboard to show when the data was last updated based on the scheduled refresh time.

Can someone please help me.

[v-alq-msft]

Hi, @Ramendra 

You may click 'Edit Query', go to 'Query Editor', create a new query, input the following codes in 'Advanced Editor'.

let
    Source = Table.FromRecords({[datetime = DateTime.LocalNow()]})
in
    Source

Then you may click 'Close and Apply' and create a card visual to display the result.

When you refresh, it will update with the latest datetime.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ramendra]

Hello

But it shows the UTC time in the power BI service. However, it displays correctly on the Power BI desktop.

[Syndicate_Admin]

query any function to place an hour of next update in an already programmed scheme? by q I already have an hour of the data update but I want to know if there is any for the next scheduled time.

[v-alq-msft]

Hi, @Ramendra 

There are some differences between the time zone you are in and the UTC. Time difference exists between Power BI Desktop and Service. You may add or minus hours to get the corresponding datetime in Power Query. I'd like to suggest you refer the blog to see if it helps.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Ramendra , refer if these can help

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/