"Transient Error" happening routinely

Thanks for lbendlin's concern about this issue.

Hi, Pfutch1 

Based on the information you provided, your Power BI model is experiencing a timeout issue when refreshing. Here are some possible causes and solutions:

The error message “Execution Timeout Expired” indicates that the query is taking too long to execute. You can try to optimize the SQL query to reduce the execution time or create indexes for the database tables.

Make sure your local data gateway is up-to-date and has enough resources. Sometimes increasing the gateway's memory or CPU allocation can resolve performance issues.

Check for network latency or connectivity issues between the Power BI service and the SQL server. Consistent network performance is critical for successful data refreshes.

Large amounts of data can cause timeouts. You might consider breaking data into smaller chunks or using incremental refreshes to manage large data sets more efficiently.

If multiple refresh tasks are running at the same time, this can lead to resource contention. Staggered refresh schedules may help alleviate this problem.

Ensure that your SQL server is configured to handle the load, including checking maximum server memory settings, query timeout settings, and making sure that the server is not overcommitted by other processes.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.