All Item - Data Owner

[HiagoSiqueira06]

Good morning,

I need to create an indicator to know which update in my workspace caused a problem, I need to know the date and time of the semantic models update

[Greg_Deckler]

@HiagoSiqueira06 Are you saying that for all semantic models you want a single place where you can see the latest refresh times?

[HiagoSiqueira06]

That's right, I need to create monitoring for updates for all my Workspaces in a single dashboard

[Anonymous · Accepted solution]

Hi @HiagoSiqueira06 

You can use Power BI REST API or Power BI Cmdlets for PowerShell to get the refresh history data of all semantic models in all workspaces. Some APIs may require that you have admin permission of the scope you are querying from. 

The process mainly includes three parts:

1. Get all workspace IDs

2. Get all dataset (semantic model) IDs in all workspaces

3. Get refresh history of all datasets

Then you can bring this data into Power BI and remain only the latest refresh history of each dataset, and create a dashboard to monitor their status. 

Here are the official documentations for Power BI REST APIs and Power BI Cmdlets:

Power BI Cmdlets reference | Microsoft Learn

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

Here are some related blogs which provide detailed guidance and steps:

Get dataset list with PowerShell - Microsoft Fabric Community

Get historical refresh records for all datasets wi... - Microsoft Fabric Community

Extract refresh metrics for your entire Power BI workspace – Data – Marc (data-marc.com)

Hope this would be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!