Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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!