Forum Discussion
Suggest me Auto refresh steps for Power BI reports when scheduled refresh fails
Use your favorite scripting tool. You can call the API from Powershell, or you can even use Power Automate actions.
Power BI - Connectors | Microsoft Docs
Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs
- subscribe to the refresh failure notification emails
- based on the received error type make a decision if another refresh should be attempted. This would be ok to try for timeout or memory issues (there's always hope) but should be avoided for data quality related issues (missing column etc)
- trigger an API refresh request
You should not need to download the PBIX, refresh it on the desktop and re-publish to the workspace, except when you need to correct meta data issues in your dataset's data sources.
Hi lbendlin,
Please elaborate me how to trigger an API refresh request in power bi service.
Thanks,
AshDil
Use your favorite scripting tool. You can call the API from Powershell, or you can even use Power Automate actions.
Power BI - Connectors | Microsoft Docs
Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs