title: SSRS Report Timeout inside Business Intelligence Studio
body: <p>Currently I am trying to "refresh fields" inside Business Intelligence Studio and I am getting the following error:</p>
  
  <p>"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."</p>
  
  <p>Background Information:</p>
  
  <ol>
  <li><p>Microsoft Visual Studio 2008</p></li>
  <li><p>Report is pretty complex, usually takes 30-60 seconds to complete (depending on filtered criteria entered)</p></li>
  <li><p>The timeout happens around 30 seconds after inputting parameters.</p></li>
  <li><p>Query Type: Text</p></li>
  </ol>
  
  <p>Things I have tried:</p>
  
  <ol>
  <li><p>Setting the "Connect Timeout" to 6 minutes on the Connection String for the Data Source.</p></li>
  <li><p>Tools -> Database Tools -> Query and View Designers, increased Cancel After to 10 minutes.</p></li>
  <li><p>Setting parameters to make sure it won't return data (speed up execution time)</p></li>
  <li><p>SELECT TOP 0 in the query.</p></li>
  </ol>