cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KV_PowerBI
Frequent Visitor

Power BI refresh error : Microsoft SQL: Execution Timeout Expired.

Hello ,

I have a power BI dataset that retrives data from Azure SQL database and sharepoint excel file .. The dataset is scheduled for refresh overnight and it normally takes around 6-12 minutes to refresh . 

But all of a sudden the scheduled data refreshes are failing with following error after around 4 hrs 

" Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. The exception was raised by the IDbCommand interface. " 

 

There is no issue while connecting to the Azure SQL database or the sharepoint excel from power bi desktop. I have checked this already. Howvere refresh doesn't work in PBI service or in PBI desktop. 

 

What could be the reason for this ? Can anyone give pointers for trouble shooting this ? 

 

Thanks 

Kalyani

1 REPLY 1
jaideepnema
Solution Specialist
Solution Specialist

Hi @KV_PowerBI

This is because refreshes timeout after 2 Hours for Pro License and after 5 Hours in Premium License. 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#sch...

 

Please accept this as a solution if your Question has been answered !!

Appreciate a Kudos 😀

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.