Solved: Data refresh end time query

andicornejo12 · ‎11-08-2023

Hello,

I have the request to show the end time of when the data refresh happened in a table of the report using the dataset.

I have searched but it seems there is no a solution for this?

If someone knows the trick would be super helpful!

Thank you!

Daryl-Lynch-Bzy · ‎11-08-2023

Hi @andicornejo12, you need to use the Power BI Rest API Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn to extract this detail.

But is it your intention to include this within the current dataset?

If so, it will be difficult to do without using an XMLA endpoint to refresh a specific table in your model. It easier to include an approximate start time [DateTime.FixedLocalNow() fucntion] in the current refresh.

View solution in original post

j_ocean · ‎11-09-2023

I once had a similar request and they stopped asking with a simple start time. Just a DateTime.FixedUtcNow() in one of the first steps.

...a people solution is sometimes easier than a technical one.

Daryl-Lynch-Bzy · ‎11-08-2023

Hi @andicornejo12, you need to use the Power BI Rest API Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn to extract this detail.

But is it your intention to include this within the current dataset?

If so, it will be difficult to do without using an XMLA endpoint to refresh a specific table in your model. It easier to include an approximate start time [DateTime.FixedLocalNow() fucntion] in the current refresh.