databases | sql database
51 TopicsEnvironment Copy/Duplicate
Why is there still no single tool to copy/duplicate an environment. Its seems that an MCP nor Deployment Pipelines can do all the necessary tasks to copy the whole of an env in its entirety, ie all artefacts and warehouses/lakehouses etc such for either 1) creation of a new environment like Pre Prod, Staging or to quickly replicate an environment. I know that using a combo of tools it can be done. But surely Fabric has matured enough for this to be available by now or have i missed something ?9Views0likes0CommentsAllow Workspace Identities as an authentication method for Fabric SQL Databases
Currently the only method of authentication in Fabric pipeline connections to Fabric SQL databases is using OAUTH2, meaning that the credentials of a specific user need to be used (with all the attendant issues around user/credential expiry). By allowing the option of workspace identity for authentication, no user creds would be needed. Obviously correct access controls would need to be defined, but that's standard SQL Server maintenance.394Views11likes1CommentKeep Fabric SQL Endpoint Up to Date
When data is updated in a Fabric Data Warehouse or Lakehouse, it's not always up to date immediately when querying the SQL Endpoint. The same thing happens in a Fabric SQL Database but this is even more noticeable - on the SQL Database object, the data is always up to date, but on the SQL Endpoint object of the same database, the data can lag. It is possible to refresh this as part of a pipeline by including the refresh SQL endpoint activity, but in my view the data should always be up to date through the endpoint as this can lead to discrepancies.13Views0likes0CommentsFabric SQL Database names: Remove GUID suffix
When provisioning a new Fabric SQL Database, after typing in the name I want, what I get is that name PLUS some random GUID characters. This just seems wrong. Nobody likes to have their stuff renamed. As I understand it by someone from Microsoft in the Fabric Community, this was done to ensure a unique name across the entirety of Microsoft Fabric. It would be nice if that was NOT a requirement. Maybe you can make it like Fabric Warehouses where it is the combination of the Tenant, Workspace, and Data Warehouse name that needs to be unique.3.5KViews20likes3CommentsCannot configure writeback for plan with guest account
It seems like it's not possible to configure writeback for a plan with a guest account. Please fix this as we use guest account to work in customer environments to avoid purchase of additional Power BI Pro licenses. Activity ID 8d5c3527-faea-4b7d-95b7-f7e6f10c819a Request ID f5d32f7e-b69d-454d-8531-818f3f165c18 Error Time Fri Jul 31 2026 16:17:28 GMT+0200 (Central European Summer Time) Service version 13.0.28509.443 Client version 2607.1.30035-train Cluster URI https://wabi-west-europe-redirect.analysis.windows.net/ Stack Trace Failed to fetch SQL credentials (status 500). 'tid' claim in the token does not match the tenant ID in the request header.22Views0likes0CommentsCollate SQL Database
Our company wanted to migrate their data from an SQL Server database to Fabric. The database we wanted to migrate has a specific collation, in particular it is case sensitive. It would be nice if we could alter the collation of SQL Databases to make migration easier.1.3KViews2likes11CommentsSupport for Always Encrypted / Client-Side Column Encryption in Microsoft Fabric
We currently have two important use cases—one in the financial sector and another in healthcare—where administrators need to manage and operate the platform, but under no circumstances must they be able to read sensitive data. SQL Server already provides a proven solution for this scenario through Always Encrypted with client-side column encryption. This feature ensures that even database administrators cannot access the plaintext values of highly sensitive columns. For both use cases, support for a similar capability in Microsoft Fabric would be a key requirement for migration to the platform. In our scenarios: Sensitive data would remain encrypted at all times within Fabric. Administrators could manage workloads, operations, backups, and performance without being able to view the protected data. If encrypted tables appear in a mirrored database, it would be acceptable for the encrypted columns to remain unreadable. Alternatively, an option to exclude such tables from mirroring would also be a valid approach. This capability would significantly strengthen Fabric's position for regulated industries such as banking, insurance, healthcare, and public sector organizations where separation of duties and data confidentiality are mandatory requirements. Question to the community and product team: Are there plans to support a Fabric equivalent of SQL Server's Always Encrypted with client-side key management and column-level encryption?82Views0likes0CommentsEnable Connection from Fabric Notebook to Fabric SQL Database
The core issue is the inability to directly access Microsoft Fabric SQL Databases from within Fabric Notebooks, despite the availability of JDBC and ODBC connection strings. The built-in notebook authentication token library appears to be missing Fabric SQL as an option. It does not currently appear possible (or at least not documented how) to access a Fabric SQL Server Database from within a Fabric Notebook. I see JDBC and ODBC connection strings, but these don't work apparently because the library to create authentication tokens is missing Fabric SQL as an option. Current Impact 1. Enterprises must create complex workarounds ("Rube Goldberg architectures") to establish basic data flows that leverage SQL Server 2. The platform fails to deliver on its "unified" promise, leading to a loss of faith in the Fabric brand 3. SQL Server's established strengths are not being leveraged effectively, further eroding trust that Fabric can deliver on enterprise data needs Summary This is a critical feature request that highlights a significant gap in Microsoft Fabric's platform integration. The inability to easily access Fabric SQL Databases from Fabric Notebooks undermines the platform's unified vision and creates unnecessary complexity for enterprise users. The request is well-justified, technically feasible, and would bring significant value to the platform.4.1KViews9likes4Comments