Forum Discussion
Fetching Semantic Model Refresh Date Time in Reports
Hi All!,
Recently we got requirement from client to show the Refresh Start Datetime and Refresh End Datetime of the semantic model in the report visualization to know the last successful refresh timing in Power BI report. We have scheduled refresh for every 30 mins (48 times a day) in the semantic model level in service. A single refresh takes more than 30 mins to complete. Also we may face refresh failures in any of the scheduled refreshes.
In order to get Refresh Start Time and Refresh End Time of the semantic model, I have created two tables with DateTimeZone.UtcNow() M function in Power Query Editor and pushed it to service. But I don’t know how to customize the order of data processing in tables while refreshing a semantic model. Both Refresh Start Time table and Refresh End Time table refreshes simultaneously.
So, I want my Refresh Start Time table to refresh or load first in the semantic model and Refresh End Time table to load last ie., after the completion of all other tables in the semantic model.
Is there a way to customize the order of table refreshes in Power BI service?
Or Is there any other approach to achieve my requirement?
Thanks in Advance!!
Hi PowerBI_Mallow ,
You can use the Power BI API to achieve this. There is some complexity in setting it up though.
Here is some additional information:
Using the API:
https://learn.microsoft.com/en-us/rest/api/power-bi/#next-steps
Get refresh history (including start and end times)
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
3 Replies
- djurecicSuper User
Hi PowerBI_Mallow ,
You can use the Power BI API to achieve this. There is some complexity in setting it up though.
Here is some additional information:
Using the API:
https://learn.microsoft.com/en-us/rest/api/power-bi/#next-steps
Get refresh history (including start and end times)
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
- PowerBI_MallowFrequent Visitor
Hi djurecic ,
Thanks for your response!
As you mentioned using Power BI API with Dataset permissions is quite complex to achieve. Can you please add any references or blogs that has implementations for achieving my requirement.
- djurecicSuper User