Forum Discussion

sshetty014's avatar
sshetty014
Frequent Visitor
4 months ago
Solved

WH is not displaying Stored procedure

Hi Team, I’m facing a serious issue in our Fabric development workspace and need assistance understanding the root cause and resolution. Our Fabric Warehouse has suddenly started behaving unexpecte...
data engineering
  • v-achippa's avatar
    v-achippa
    3 months ago

    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

sshetty014's avatar
sshetty014
Frequent Visitor
3 months ago

hi Srisakthi ,

hi  ,
We are using OAuth2.0. I also checked with my admin , we havent changed any permission. And we are facing issue in the fabric warehouse UI because we are able to see the SPs when im connected with SSMS and also able to execute the SP in smms but not in Fabric UI.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
3 months ago

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

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    3 months ago

    Hi sshetty014,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the issue is resolved? or have you raised a support ticket?

     

    Thanks and regards,

    Anjan Kumar Chippa