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, wh...
Need Help
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.