Power BI data refreshed issue

Hi RajeshKannanS ,

The error usually occurs because the Snowflake connection is forcibly closed due to session timeouts, network interruptions, or Power BI Service query execution limits. Even if your gateway timeout is high, Snowflake or network policies might close idle or long-running sessions.

Snowflake-side settings to check:

• Increase Snowflake CLIENT_SESSION_KEEP_ALIVE to prevent session timeouts during long queries.
• Review and adjust network policies or firewall rules that might terminate idle TCP connections.
• Check Snowflake’s query timeout and warehouse auto-suspend settings to ensure the warehouse stays active.

Power BI Service considerations:

• Power BI Service imposes a maximum refresh timeout of 2 hours; queries taking longer will fail.
• Large datasets (51 million rows) can lead to heavy resource consumption; consider incremental refresh to reduce load.
• Snowflake’s Arrow format is usually stable, but if errors persist, try switching to DirectQuery or using a different connector/driver version.

Recommendations:

• Enable incremental refresh in Power BI to reduce dataset size per refresh.
• Coordinate with your Snowflake admin to adjust session keep-alive and network settings.
• Monitor and optimize your Snowflake warehouse size and query performance.
• If possible, test refreshes with smaller data subsets to isolate issues.