My stored procedure runs fine in SQL and I can run it in SSRS, however when I got to the dataset properties of the dataset to refresh the fields it gives me the following error:
Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct. When I click on details it states Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I have my time out (in seconds) set to 5,000.
I sent my RDL to a coworker and they were able to refresh the fields with no problem. Already restarted my computer, any ideas on why it would work for my coworker and not me?