Forum Discussion

PowerBI_Mallow's avatar
PowerBI_Mallow
Frequent Visitor
2 years ago
Solved

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!!

3 Replies