I am using SSRS and adding a shared dataset based on a stored procedure with parameters. When I go to refresh the fields so Visual Studio adds the correct parameters and fields, sometimes I get the following error message:
Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.
The detail message is
Procedure or function 'SP NAME' expects parameter '@parameter name', which was not supplied.
The problem happens quite randomly. Sometimes it works, other times it doesn't. Doesn't matter what is inside the stored procedure. Without the fields and parameter list, you can not add the data set to a report.