Power BI Report with Semantic Model Refresh Failures

Hi Gusd8 ,

Based on your description, you want to create a report to show the refresh of different semantic models.
The first way you can do this is by looking at the refresh summary for power bi. the Power BI Refresh Summary page in the Power BI Management Portal allows you to control and understand the overlap of refresh schedules, capacity, and potential refresh schedules for Power BI Premium capacity. Here you can export to excel file and then analyze it.
Refresh summaries for Power BI - Power BI | Microsoft Learn
In the second method, you can use rest api to get the name of the library and refresh history. Then use these to create reports.
You can check these documents for more information
Datasets - Get Datasets In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Extract refresh metrics for your entire Power BI workspace – Data – Marc (data-marc.com)

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly