Forum Discussion

JSeb's avatar
JSeb
New Member
9 years ago

Refresh times out every time

Hi,

I have issues refreshing a dataset in PowerBI. Either with scheduled refreshes, or manually triggered refresh, it always times out.

The same dataset can refresh from PBI Desktop. This is an issue that appeared recently.

Is there a change in the default time out? Where can I change it?

Thanks!

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    JSeb How long is it taking in the Desktop? Have you checked the Gateway log files to determine what the specific issue is?

    • JSeb's avatar
      JSeb
      New Member
      9 years ago

      Hi Anonymous

      Actually I mispoke, it seems Desktop PBI can't refresh this dataset anymore neither. Both used to work but were taking a long time (about 15 to 20 minutes) but now time out.

      I don't have any gateway, it is a direct SQL connection to SQL Azure.

      I found that if I change the scale of my SQL database to P4 (about $2000/month), the refresh works again. However this used to work just with my current instance and I'd prefer to increase the timeout time.

      Thanks

      JS

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        JSeb You could take a look at this thread in which it explains how to set the timeout in the M code, I don't know if that will work for a DQ connection though. The other aspect i am uncertain on is whether or not that will actually work in the Service.

        My advice would be to look at performance tuning the queries in the database...

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi JSeb

     

    What about changing the"Command Timeout in Minutes" when configuring the SQL Server Database Source?


    I do know that you can configure this timeout, as well as ensure what the default timeouts are set to for your SQL Server Database.

    And as Anonymous suggests, also make sure you have tuned your queries and database for optimal performance.