I am not getting my Stored Procedure in drop down in STORED PROCEDURE ACTIVITY of Azure Data Factory

Question

I am using Azure Data Factory for my ETL pipelines, I have created Stored Procedure in my database. I have that Stored Procedure in both (Azure Data Studio and Azure Portal). But when I am trying to use stored procedure in ADF, I am getting nothing in drop down. I have checked that my linked service is fine, even I have created new one also but no luck. I got 2 Stored Procedures in my DB, But none of them are visible in STORED PROCEDURE ACTIVITY in ADF. Any Idea what would be the problem here.?

Below is the image of the issue I am facing. enter image description here

I tried creating a fresh linked service, but no luck. I tried to manually enter Stored Procedure name but no luck.

Answer 1

To view the stored procedure from azure Data factory stored procedure activity make sure you have configured correctly ac below:

• Make sure you are using correct user to authenticate from Azure Data Factory.
• Make sure the stored procedure is exist on the data base.
• Make sure the user you are using to authenticate has execute permission on respective stored procedure.

GRANT  EXECUTE  ON  OBJECT::SACHEMA.storedprocedure TO ROlE;