Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PowerBI_Mallow
Frequent Visitor

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

1 ACCEPTED SOLUTION
djurecicK2
Super User
Super 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

 

 

View solution in original post

3 REPLIES 3
djurecicK2
Super User
Super User

Take a look at this to get started:

https://adamtheautomator.com/power-bi-api/

 

djurecicK2
Super User
Super 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

 

 

Hi @djurecicK2 ,
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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors