Forum Discussion

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
2 months ago
Solved

View all workspace refreshes

Hi,   Is there a way to view all reports in a workspace in an export or database view?   I also need to see all refreshes, is there a way to see all in a holistic view instead of having to go int...
Need Help
  • v-abhinavmu's avatar
    v-abhinavmu
    2 months ago

    Hi lherbert501,

    Thanks for the clarification. and thanks to FBergamaschi for sharing valuable insights.

    If you're a Power BI Premium capacity administrator, you can use the Refresh summary page in the Power BI Admin portal. It provides a consolidated History and Schedule view of scheduled refreshes for the Premium capacities you administer. The History view shows recent scheduled refreshes, while the Schedule view helps identify refresh schedule overlaps. You can also export the refresh information to a CSV for further analysis.

    If you're looking for refresh history programmatically, the Get Refresh History REST API is also available. It returns the refresh history for a specified dataset.

     

    For more information, please go through below offical documentations:

    Refresh summaries for Power BI - Power BI | Microsoft Learn

    Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn

     

    I hope this helps. Please feel free to reach out if you have any further questions.
    Thank you.

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
1 month ago

Hi v-abhinavmu ,

 

Thankyou for this. This view only shows 1 refresh.

 

Is this going to be down to capacity settings? If you don't have premium capacity then you can't see refreshes, is that right?

 

Thanks

v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
1 month ago

Hi lherbert501,

 

According to the official documentation, the Refresh summary page in the Power BI Admin portal provides History and Schedule views for scheduled refreshes on Power BI Premium capacities that you administer, and you can export the refresh details to a .csv file.

 

For refresh history through the REST API:

  • Get Refresh History returns the refresh history for a specified semantic model (dataset).
  • Get Datasets In Group returns the list of semantic models (datasets) in a specified workspace.

For more details, please refer to  the below official documentation:

Refresh summaries for Power BI - Power BI | Microsoft Learn

Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Datasets - Get Datasets In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

 

I hope this helps. Please let us know if you have any further questions.

Thank you.

  • v-abhinavmu's avatar
    v-abhinavmu
    Icon for Community Support rankCommunity Support
    1 month ago

    Hi lherbert501,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestion worked. Please feel free to contact us if you have any further questions.

     

    Thank you.