WH is not displaying Stored procedure

Hi sshetty014,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Srisakthi for the prompt response.

Thank you for the response. Since the stored procedures are visible and executable from ssms and the adf pipeline is also working successfully, this shows that the SPs are still present and accessible in the warehouse backend.

Looks like the issue is specific to the fabric warehouse UI or fabric pipeline connection metadata rather than the issue with the stored procedures. Please try below following steps:

• Recreate the OAuth2 connection used in the fabric pipeline.
• Try to rebind the Lookup activity to the warehouse again.
• Republish the pipeline.

If the issue continues even after recreating the connection and rebinding the warehouse, please open a Microsoft support ticket for further backend investigation, because this can be related to backend metadata inconsistency in the fabric workspace.

Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thanks and regards,

Anjan Kumar Chippa