Forum Discussion

MichelleRoberts's avatar
MichelleRoberts
Icon for Helper I rankHelper I
21 days ago
Solved

Refresh Errors

Hello! I have several reports that are pulling from semantic models that are built from Azure Data Lake tables. Some of these reports have email subscriptions and when I created the reports, I was t...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    13 days ago

    Hi MichelleRoberts​ 

    Thank you for clarifying your requirement. Since management needs reports at a fixed time daily, you could use Azure Data Factory to orchestrate the semantic model refresh, with retries and status monitoring before triggering report delivery.

    Please note that Power BI automatically disables scheduled refresh after four consecutive failures and this threshold cannot be changed. An API-driven refresh workflow can provide more control over retries and monitoring, but it cannot guarantee uninterrupted refreshes.

    For details, see Microsoft's asynchronous refresh documentation.

    https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

    I hope this helps!

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
16 days ago

MichelleRoberts​ 

Since you are already using ADF, I would recommend you to trigger the  refresh of your semantic models using Power BI enhanced refresh APIs, instead of using schedule refresh, that way you will have more granular control and you will be able to handle the failures easily. 

https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

After triggering the refresh you can get the refresh history to check whether the last refresh is a failure or a success. If it is a failure then you should be able to add retry attempts.  

Please note, after 4 unsuccessful failure attempts, Power BI will disable the schedule refresh on its own. Its a default bahavior. 

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#troubleshooting

Regarding the subscriptions, it will always be as per the latest data available in your data model irrespective whether your refresh is a success or a failure. 

Hope it answers your question

read my blogs here: https://www.techietips.co.in/