How to delete fabric items with an SQL Analytics endpoint in a non-PowerBI Premium environment

Hi,Jeffrey9 .I am glad to help you.

According to your description, you are experiencing the problem of not being able to change the workspace type, when you change the fabric type of workspace to another type (Premium) you are prompted that you need to remove the fabric element from the workspace.  I successfully reproduced your problem

First the solution:

You need to recheck the items in this workspace, which can only be created in Fabric license mode, such as your current item: SQL Analytics endpoint (LakeHouse), you need to move them to another workspace with the same license level or delete them all (please save the important items before you do this).

You need to move them to another workspace with the same license level or delete them all (please save the important contents before you execute them) and then you can successfully convert Fabric license (Trial) to other license types.

Unfortunately, at the moment, due to security restrictions, you can't simply transfer data from Fabric to another workspace.

You need another way to transfer data/files between two different workspaces.

Here is a link to a solution I found that you can refer to:

url: Solved: How Copy files/tables from lakehouse to another la... - Microsoft Fabric Community
Here's the document in question, which I hope will help you.
Migrating from Azure Synapse Spark to Fabric - Microsoft Fabric | Microsoft Learn

Here's what I did to reproduce your problem, and I was able to change the license after clearing all Fabric Items in the workspace (so if you want to change the license of the workspace, you have to make the items in the workspace meet the license restrictions).

In fact, it is not recommended to change the license type of a workspace directly (unless the workspace is changed to a higher level license, so that there is no content level restriction).

After deleting the lakehouse in the fabric license level's workspace, I successfully changed the level of the workspace to Premium-Per-User (I couldn't change it to Premium capacity due to environmental issues)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.