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

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

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.