Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dobregon
Impactful Individual
Impactful Individual

Timeout Refresh Error

Hi,

 

I see many topics about this issue but i haven't found what is the default timeout configured in powerbi for a database.

dobregon_0-1608023114154.png

 

I have a SP (it give us a table) that i need to load in the PowerBI that normally take 45-60min in SQL (but it runs every time) and when i tried in the PowerBI sometimes run and other times not run with the timeout error.

In the next url i can reed that by default the timeout is set to 10min, is it right?

https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-... 

 

if i dont put any number in the powerbi, the timeout is configured as default (10min as the web)? or if it is maximum number? or i need to put 0 to have maximun time of timeout or i need to put 120min?

Can someone help me on this?

 

Thanks a lot!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
1 ACCEPTED SOLUTION
dobregon
Impactful Individual
Impactful Individual

Default number if you put nothing = 10min

I have used 120min (i prefer this than a max number that could produce block the database).




Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

3 REPLIES 3
dobregon
Impactful Individual
Impactful Individual

Default number if you put nothing = 10min

I have used 120min (i prefer this than a max number that could produce block the database).




Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
amitchandak
Super User
Super User

@dobregon , I think 0 means max

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-query-ti...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks @amitchandak 

 

i will try this, in any case, do you know if not put any numbers means the default sql timeout of 10min?

Regards!



Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors