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 hours in powerbi desktop, is there an option to change the timeout time in powerbi service? I think is 2 hours

 

Best regards 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • 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.