Forum Discussion
Unable to View SQL Database (preview) in Fabric
Hello Community,
Can someone let me the permissions I would need to be granted to me to view the relatively new SQL database (preview), see image.
When I search on on SQL I don't see in my Workspace , the following is all I see
Hi carlton7372
Here’s the quick checklist to make “SQL database (preview)” show up in Fabric:
- Tenant setting
Ask your Fabric/Power BI admin to open Admin portal >> Tenant settings and turn on SQL database (preview) for your user/security group. Also ensure Users can create Fabric items isn’t blocking you. - Capacity & region
Your workspace must sit on a Fabric capacity (F-SKU or trial) where SQL database is enabled and the capacity region supports it. If the toggle isn’t available, the feature isn’t in that region yet. - Workspace placement
Move the workspace to that capacity (Workspace settings >> Advanced >> Capacity). The tile won’t appear on shared capacity. Then you should see New item >> Databases >> SQL database. - Your role
To create, be Admin/Member/Contributor in the workspace. To view an existing SQL database item, Read item permission (or Viewer with item read) is enough.
If all of the above are set, refresh the portal and search again New item >> Databases >> SQL database should be there.
https://learn.microsoft.com/en-us/fabric/admin/about-tenant-settings- Tenant setting
1 Reply
Hi carlton7372
Here’s the quick checklist to make “SQL database (preview)” show up in Fabric:
- Tenant setting
Ask your Fabric/Power BI admin to open Admin portal >> Tenant settings and turn on SQL database (preview) for your user/security group. Also ensure Users can create Fabric items isn’t blocking you. - Capacity & region
Your workspace must sit on a Fabric capacity (F-SKU or trial) where SQL database is enabled and the capacity region supports it. If the toggle isn’t available, the feature isn’t in that region yet. - Workspace placement
Move the workspace to that capacity (Workspace settings >> Advanced >> Capacity). The tile won’t appear on shared capacity. Then you should see New item >> Databases >> SQL database. - Your role
To create, be Admin/Member/Contributor in the workspace. To view an existing SQL database item, Read item permission (or Viewer with item read) is enough.
If all of the above are set, refresh the portal and search again New item >> Databases >> SQL database should be there.
https://learn.microsoft.com/en-us/fabric/admin/about-tenant-settings- Tenant setting