Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Timeout expired when refreshing

So i user Power BI service to changing data source, usually it will show error: 'Timeout expired. The timeout period elapsed prior to completion of the operation.', sometimes it refreshes successfull...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks guys, i fixed it, by optimizing the query. Aggerating and tunning help a lot in this, not only reducing the file size but also loading time

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
4 years ago

Hey Anonymous ,

a refresh will be timed out by the Power BI Service after 2 hours and after 5 hours if you are on Power BI Premium: Troubleshooting refresh scenarios - Power BI | Microsoft Docs

The only way to make sure that your refresh will always succeed is to make the Power Query as optimal as possible and identify and remove the root cause of failure.
Sometimes failure happens during peak hours of Db usage, then you might consider to upgrade the service tier (throw metal to the problem 😉 )

Hopefully, this provides some ideas on how to tackle your challenge.

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your solution. By your suggestion i've edited on Power Query step, to make it simpler. Aggregating in SQL query before putting it in Power BI, the size of the file is greatly reduce, but i still catch the failed refresh. By checking up the query, i see it took a long time to run.