Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowFabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now
During the execution of the SYN in the implementation pipeline, something went wrong, causing the Onelake to remain stuck in the destination workspace. However, I do not have the ability to remove the Onelake. Could you please advise how I can resolve this?
Thank.
Solved! Go to Solution.
Hi @Guerrero , not so long ago, I helped another person with the exact same issue, the whole conversation can be found here https://community.fabric.microsoft.com/t5/Fabric-platform/Unable-to-delete-abandoned-SQL-endpoint-fr... the accepted solution to this issue:
[...] from my article Removing Orphan Fabric Deployment Pipelines, follow Step 1: Getting the Access Token and Step 2. Configure Postman Authorization, assuming that you have the workspace where the endpoits is, have handy its Resource ID (image below show how to easily get this)
Using postman, get a list of SQL endpoint in your workspace replacing {workspaceId} with the Id of your workspace using GET over https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints (ref. Items - List SQL Endpoints - REST API (SQLEndpoint) | Microsoft Learn )
Once you have the Id of the delinquent SQL endpoint, try to delete it replacing {workspaceId} with your workspace and {itemId} with the Id of the SQL endpoint using DELETE over https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{itemId} (Ref. Items - Delete Item - REST API (Core) | Microsoft Learn)
It help that other person and i'm pretty sure it will do the same for you! Ping me if you get stuck on any of the steps; I would appreciate a kudos and if it works for you, mark as solution ... all the best mate, good luck 🤞
Hi @Guerrero
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
Hi @Guerrero
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi @Guerrero , not so long ago, I helped another person with the exact same issue, the whole conversation can be found here https://community.fabric.microsoft.com/t5/Fabric-platform/Unable-to-delete-abandoned-SQL-endpoint-fr... the accepted solution to this issue:
[...] from my article Removing Orphan Fabric Deployment Pipelines, follow Step 1: Getting the Access Token and Step 2. Configure Postman Authorization, assuming that you have the workspace where the endpoits is, have handy its Resource ID (image below show how to easily get this)
Using postman, get a list of SQL endpoint in your workspace replacing {workspaceId} with the Id of your workspace using GET over https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints (ref. Items - List SQL Endpoints - REST API (SQLEndpoint) | Microsoft Learn )
Once you have the Id of the delinquent SQL endpoint, try to delete it replacing {workspaceId} with your workspace and {itemId} with the Id of the SQL endpoint using DELETE over https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{itemId} (Ref. Items - Delete Item - REST API (Core) | Microsoft Learn)
It help that other person and i'm pretty sure it will do the same for you! Ping me if you get stuck on any of the steps; I would appreciate a kudos and if it works for you, mark as solution ... all the best mate, good luck 🤞
Hi @Guerrero,
Can you provide more details?
Are you getting any error messages? What does the pipeline look like, can you provide a screenshot?
WHat do you mean by the OneLake is getting stuck?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Proud to be a Super User! | |
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Fabric update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 11 | |
| 10 | |
| 7 | |
| 6 |
| User | Count |
|---|---|
| 40 | |
| 22 | |
| 21 | |
| 15 | |
| 14 |