Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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])
How did you manage to get dataset refresh history in Import mode?
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])