Frequently I am facing report refresh issue over the weekend (Saturday only) in the power BI service

Swathi1 · ‎01-24-2025

Following error message received,

An error occurred while processing the data in the semantic model.

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

<ccon>Timeout expired. The timeout period elapsed prior to completion of the operation.</ccon>. The exception was raised by the IDbCommand interface.

nilendraFabric · ‎01-25-2025

@Swathi1

Do you have information about size of data over weekend or are there other jobs running on same datasource ?

If weekend refreshes frequently time out, a common cause is that the dataset takes too long to process, exceeding Power BI’s refresh threshold in Pro (2 hours) or Premium (5 hours) environments

Another factor can be added strain on the data source at certain times, especially with concurrent weekend batch jobs or server downtime

Hope this helps

View solution in original post

v-tsaipranay · ‎01-27-2025

Hi @Swathi1 ,

Thanks for reaching out to the Microsoft fabric community forum.

As the error message indicates it might be transient, please wait a few minutes, then try refreshing the model again. Additionally, here are some troubleshooting steps:

If you have control over the timeout settings, consider increasing the timeout duration for the operation. This can often be set in the connection string or the settings of the tool you are using.
Monitor the server where the database is hosted. Look for high CPU, memory, or disk usage that might be causing slowdowns. If applicable, consider scaling resources (e.g., upgrading the server or optimizing the database).
Review the queries being run during the refresh. Look for any that could be optimized for better performance. Ensure that indexes are properly set on the database tables being queried.
Perform regular maintenance tasks such as rebuilding indexes and updating statistics to ensure optimal performance.

This error may result from expired cached credentials. Clear your browser cache, sign in to Power BI, and visit https://app.powerbi.com?alwaysPromptForContentProviderCreds=true to update your credentials. Data refresh failures can also be due to expired cached credentials.

I am also including troubleshooting refresh scenarios for your reference, please look into it.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

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

Thank you.

v-tsaipranay · ‎01-30-2025

Hello @Swathi1 ,

We haven't received a response from you regarding our previous suggestions on facing report refresh issue over the weekend in the power BI service. We would appreciate your feedback to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Let us know if there’s anything else we can do to help.