Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Timeout refreshing data

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 h...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
lbendlin
Super User
6 years ago

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