Scheduled Refresh in power bi throws error in PBI Service?

[ssspk]

Hello Team,

I am getting the below error in the Scheduled refresh configuration,

Refresh is not happened.

What could be the reason.? All Status failed are showing the same error.

I am connecting Databeicks Schema from Power BI Service.

Thanks,

Siva

[Anonymous · Accepted solution]

Hi @ssspk ,

The error means the capacity might be overloaded at that time. If you want to work with many datasets at the same time you have to make sure the data model is well done, best practices involved. You can also make sure you downsize it with all practices: https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

Once all that is done check how time it takes to refresh. Analyze the refresh times of the capacity to make sure there isn't one single time that is refreshing 90% of the datasets. Maybe you can do it every 30 minutes except the time that are refreshing alot of them. Also talk with users to check if it's really neccesary the 30 minutes or if it's just because "they want". It's not very frequent the scenario. 

If you have done all that and still having the error, you might want to consider incremental refresh to reduce the refreshes at the data models in order to avoid the overload.

At the end of the day if any of that works, you might need to increase the capacity.

I hope that helps.

Below is the official link will help you:

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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

[Ray_Minds · Accepted solution]

Hi @ssspk 

We need to upgrading the Licence of Power BI.

• Power BI allows up to 8 scheduled refreshes per day for datasets in Power BI Pro. However, if you need to refresh your data more frequently than that, you can consider upgrading to Power BI Premium or Power BI Embedded, which provide more options for refreshing your dataset

• Premium license is 48 refreshes per day, Maximum refresh frequence of 30 min.

• Large semantic models in Power BI Premium will help to improve the data set refresh.
  
  If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[Anonymous]

Hi @ssspk ,

Has your problem been solved and if so, please mark the correct answer as solution.

Best Regards,

Xianda Tang

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

[Anonymous · Accepted solution]

Hi @ssspk ,

The error means the capacity might be overloaded at that time. If you want to work with many datasets at the same time you have to make sure the data model is well done, best practices involved. You can also make sure you downsize it with all practices: https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

Once all that is done check how time it takes to refresh. Analyze the refresh times of the capacity to make sure there isn't one single time that is refreshing 90% of the datasets. Maybe you can do it every 30 minutes except the time that are refreshing alot of them. Also talk with users to check if it's really neccesary the 30 minutes or if it's just because "they want". It's not very frequent the scenario. 

If you have done all that and still having the error, you might want to consider incremental refresh to reduce the refreshes at the data models in order to avoid the overload.

At the end of the day if any of that works, you might need to increase the capacity.

I hope that helps.

Below is the official link will help you:

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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