cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

"Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Data Flow

Hi All,


I am attempting to refresh a data flow in Power BI Service but getting the below error:

Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Request ID: 62f50212-2ddb-3bfa-6a11-861a68020c5c Activity ID: 483c4322-fe07-4903-885f-64c7652f3c83

 

This error occurs on a large fact table. Is it possible to up this timeout period somewhere? Other forum posts I have seen have suggested how to do this in Desktop but not Service.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: "Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Da

I found this about Azure databases

"As you noticed, connecting to Azure SQL DB is a little different from connecting to a Microsoft SQL Server. Generally for Azure, you connect to individual databases, not an entire server - so there's really no concept of configuring server timeout settings"

 

I think this means that you cant do anything about the timeout on the SQL DB side?

View solution in original post

3 REPLIES 3
Highlighted
Memorable Member
Memorable Member

Re: "Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Da

Hi @SamJHannan ,

 

In the Data Source Settings for the SQL Server database you can increase the timeout.  (You can modify it in the Data Source Settings itself or if this is just one place you are using it, you can modify it in the M code in the Source line.)

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Highlighted
Super User II
Super User II

Re: "Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Da

Interesting one. After some research, the table its self isnt going over the size limits. If you change it to a view and add this to Power BI instead it works fine.

 

Could there possibly be any issues with using tables with a Column Store Index on them?

Highlighted
Super User II
Super User II

Re: "Error: DataSource.Error: Microsoft SQL: Execution Timeout Expired" When Refreshing Da

I found this about Azure databases

"As you noticed, connecting to Azure SQL DB is a little different from connecting to a Microsoft SQL Server. Generally for Azure, you connect to individual databases, not an entire server - so there's really no concept of configuring server timeout settings"

 

I think this means that you cant do anything about the timeout on the SQL DB side?

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors