Get refresh history on direct query mode dataset using power BI client

[murali_r]

I generated the report using direct query mode and embed it in UI. I want show refresh history / recent refreshed also in UI. If the report in import mode ,i can able to get refresh history but here
I am using direct query mode and I am getting "unsupported media type" error . please update ifany idea on this.

[nikit]

How did you manage to get dataset refresh history in Import mode?

[GilbertQ]

Hi there,

There are details in this blog post here: https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

[GilbertQ · Accepted solution]

Hi @murali_r

If you are using DirectQuery, the data is always as current as the underlying system.

What I would suggest doing is to look at a DateTime column in your dataset that has got the values for your data.

Then you could create a measure which will get the MAX DateTime, which you could then put into a measure

Last Date = "Data as at: " & MAX('Table1'[MyDateTimeColumn])