Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Raja10ram

Issue in Loading the Schedule Refresh

Submitted by Helper I on ‎02-17-2025 10:50 PM

Hello PowerBI Guys,

 

I am facing one issue while Schedule Refresh in Power BI Service.

Issue is i had set 4 time to refresh it was working fine but out of 4 it was fail 1 time with an error is attached in the Sceen Shot.

 

Raja10ram_1-1739861184941.png

 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎02-18-2025 09:52 PM

Hi,@Raja10ram .I am glad to help you.

Based on the screenshot of the error message you provided, it could be caused by an unstable internet connection. This is because you mentioned that one of the four refreshes failed. This indicates that your overall gateway configuration (data source credentials, etc.) settings are correct (there are success stories)
And in Power BI Service, it's not unusual to have occasional refresh failures.
There are many factors affecting refresh failure:

Stability of the gateway: If the gateway is not stable, it may lead to interruption of data transmission.
Database access: The response time and availability of the database can also affect the refresh success rate.
Network connection: The stability and speed of the network connection is a key factor.
Available capacity of the system: The system load and available capacity of Power BI Service can also affect the refresh operation.
You can check/optimize the refresh configuration from the following aspects:

Check network connection:

Ensure that the network connection is stable to avoid interruptions during the refresh process.
Use a wired connection instead of a wireless connection to improve network stability.
Update Gateway:

Ensure that you are using the latest version of the Power BI gateway.
Check the gateway logs regularly to troubleshoot possible connectivity issues.
Optimize data source settings:
Ensure that the privacy levels of the data sources used in the gateway are consistent.

Try to segregate data-heavy Scheduled Refresh operations from other Scheduled Refresh operations in your team. Avoid multiple refresh operations running concurrently in a short period of time, which can consume capacity resources and lead to refresh failures.
If possible, reduce the frequency of refreshes and ensure that there is sufficient time between refreshes.
URL:

Solved: Re: Power BI Server - Refresh failing in random ma... - Microsoft Fabric Community


I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

Idea Statuses