Forum Discussion
All Item - Data Owner
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!
HiagoSiqueira06 Are you saying that for all semantic models you want a single place where you can see the latest refresh times?
That's right, I need to create monitoring for updates for all my Workspaces in a single dashboard
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!