Forum Discussion
The database cannot be mirrored to Fabric due Data Factory disabled
richard-aik I am glad that suggestion helped. If you have useful items in your original workspace that you want to replicate you may be able to do that using Git integration. If you have to move data, you'll need to use a copy job or activity for that.
Back to your original issue. Generally speaking, the fact that a workload's runtime is not available means the workspace cannot reach a Fabric capacity that runs all the runtimes. One trick you could try to save your workspace is to reassign the workspace to another capacity and then back. Sometimes some metadata gets corrupted behind the scene due to frequent Fabric updates especially if you did not touch the workspace for some time.If you find this answer useful or solving your problem please consider giving kudos and/or marking as a solution.
Super Userrichard-aik What is your role in the workspace? To create items you need to be a member or a contributor. I also see that your workspace is shared - the additional three-dot-circle icon. I am not sure what that could affect.
I don't think that the errors you see are real. I am not aware of any way to disable a Factory runtime in Fabric specifically in the context of a capacity. I think those errors are in reaction to your permissions. You also need to have a Power BI Premium personal license to work with Fabric that you should see in your account in the top right corner.
Please check your license and permissions. The better way is to create a new workspace, assign a Fabric capacity to it and try to create your items there. The shared workspace permissions/settings may be interfering with what you can do.
apturlov I'm the Fabric Administrator.
I managed to create new workspaces, and it is able to create sql mirroring without any issues.
Yes, at this stage, it looks like I have to blow away the workspace. Very unfortunate as there's no fix can be done to the workspace.