Only 3 stored procedures are presented to me in the SSRS designer when I am trying to create a dataset

Tom Stone 521 Reputation points
2021-01-29T21:08:48.247+00:00

Only 3 stored procedures are presented to me in the SSRS designer when I am trying to create a dataset.
There should be 30+ stored procedures to choose from.
Why is this happening?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,908 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,826 questions
{count} votes

2 additional answers

Sort by: Most helpful
  1. Michael Taylor 49,251 Reputation points
    2021-01-29T22:26:09.793+00:00

    This appears to be a duplicate of this.


  2. Joyzhao-MSFT 15,566 Reputation points
    2021-02-02T02:01:23.393+00:00

    Hi @Tom Stone ,
    When you select a different data source, the corresponding stored procedure will appear.
    Please check whether your 30+ stored procedures are all using the same data source.
    62781-01.jpg
    62743-02.jpg

    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 3: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html