Timeout refreshing data

[miguel1206]

Hi all,

I have a large dataset in which i have configured incremental refresh, the problem is when I publish to PowerBI service appears timeout issue because the history is refreshed in about 4 hours in powerbi desktop, is there an option to change the timeout time in powerbi service? I think is 2 hours

Best regards 

[lbendlin]

whch driver are you using? Does it have an ODBC equivalent?  In ODBC you can set connection timeout and query timeout.

[miguel1206]

Thanks @lbendlin I'm using the SQL Server connection, my source is an Azure SQL Server

I have tried the CommandTimeout=#duration(0,4,0,0)] in advanced editor  but doesn't work for me 

Best regards 

[lbendlin]

CommandTimeout is just for the initial connection.  You want the QueryTimeout which is not exposed in the native SQL connector.  Try ODBC.