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?
Thank you