Forum Discussion
How to delete fabric items with an SQL Analytics endpoint in a non-PowerBI Premium environment
I have the same problem, but I get stuck in a loop:
I've created a Lakehouse in My Workspace. A Lakehouse (with a Semantic model and SQL analytics endpoint) was created. Now I want to delete this Lakehouse. The Lakehouse disappeared, but the Semantic model and SQL analytics endpoint are still there. When I want to delete those, I've got the error message: Unable to open the SQL analytics endpoint because it was created in Power BI Premium. To open the SQL analytics endpoint, upgrade to Power BI Premium.
When I want to change the License type in My Workspace Settings (from Pro to Premium) I get the same error as Jeffrey9: My workspace workspace cannot be reassigned because it includes Fabric items or you're attempting to move them across regions. This is not supported currently. Remove the Fabric items, or move the workspace within the same region, and then try again.
So I have to delete the Fabric items in order to change to Premium, but I can’t delete the Fabric items because I'm not in Premium capacity…
Any way to fix this loop?
Hi,Sander95
I understand your concern, in fact, when I tried to remove the datalake during my test last week, service removed the datalake, but the SQL EndPoint that was automatically created by the system was not immediately removed, but when I now revisit the worksapce that I was testing at the time, I see that the contents have all but disappeared, lol! I think it may be a network latency issue, may I ask you now those elements that should have been deleted have disappeared?
There is nothing in the test workspace Which I created last week.Thanks for answering my question!
Deleted it a couple of weeks ago, but both the SQL Endpoint and Semantic Model are still there.
The 'Delete' option has now dissapeared, because of the error message I guess.