Timeout Refresh Error

[dobregon]

Hi,

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

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!

[dobregon · Accepted solution]

Default number if you put nothing = 10min

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

[amitchandak]

@dobregon , I think 0 means max

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

[dobregon]

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!