Forum Discussion

Ano's avatar
Ano
Icon for Microsoft Employee rankMicrosoft Employee
9 months ago

Need to view the Lakehouse missing SQL Endpoint in Power BI service UI.

Metadata refresh failure in the Lakehouse SQL catalog due to Error "exceeding the database request limit". This resulted in SQL query failures linked to the DataflowsStagingLakehouse SQL Endpoint, which is not visible in the Fabric UI.

 

 

 

Customer is looking for Lakehouse SQL Endpoint to be visible in Power BI service UI. 

Microsoft Product team's help will be much appreciated.

Need Help

4 Replies

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    9 months ago

    Hi Ano, 

     

    Is there another lakehouse or warehouse in the workspace that you can get the connection link from? 
    SQL Endpoints are the same across a workspace, so all items will have the same SQL Endpoint. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

    • Stef_Fabric's avatar
      Stef_Fabric
      New Member
      9 months ago

      Hi tayloramy, 

       

      This post was submitted by Ano after an issue we encountered. 

      Some clarifications here: The issue is not the endpoint not being visible. It's the whole Lakehouse/Warehouse that isn't visible in the workspace. So our only option is to use specific links with the correct object ID in it if we want to be able to view that Lakehouse. 

       

      Hope that clarifies. 

       

      Kind Regards

      • tayloramy's avatar
        tayloramy
        Icon for Super User rankSuper User
        9 months ago

        Hi Stef_Fabric, 

         

        Oh that's fun. Is this a staging lakehouse that was created automatically? I've seen that for staging lakehouses, they're not intended to be used for anything other than Fabric's internal staging. 

         

        If it was a lakehouse you created, I've never seen that. If so report as a bug ASAP. 

         

        If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi Ano ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Thank you for submitting an idea in Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements. I have posted your idea link, it will help other community members to upvote the idea.

     

    Need to view the Lakehouse missing SQL Endpoint in... - Microsoft Fabric Community

     

    Thank you for being a valued member in Microsoft Fabric Community Forum

    Regards,

    Dinesh