Share your ideas and vote for future features
Suggest an idea
Options
- Mark all as New
- Mark all as Read
- Float this item to the top
- Subscribe
- Bookmark
- Subscribe to RSS Feed
Showing ideas with label Databases | SQL Database.
Show all ideas
Submitted on
03-19-2025
02:53 AM
Submitted by
BobDuffyIRL
on
03-19-2025
02:53 AM
Currently the server name for SQLDB (and DW) is a double GUID of {tenant-Id-workspace-id.}database.fabric.microsoft.com This causes a lot of issues as 1. This is impossible to remember 2. We ahve no way to distinguish test from PRD We request user frirnedly DNS Names like Prodata-Sales-DEV.database.fabric.microsoft.com This would help clearly label an worksapce as DEV or PRD and avoid confusion and make the platform easier to work with.,
... View more
See more ideas labeled with:
-
Data Engineering
-
Data Warehouse
-
Databases | SQL Database
Submitted on
03-19-2025
02:47 AM
Submitted by
BobDuffyIRL
on
03-19-2025
02:47 AM
When we connect to the DB we have to enter the Database Name whgich is a GUID. Please make this database name equal to the same name as trhe SQL End Point and database name in Fabric. This imporves usability, and allows for the same 3 part TSQL to run on SQL DB v SQL End Point. At the moment we have different TSQL Statements if we query SQLDB v SQL End Point which is not optimum
... View more
We will remove the guid, but I don't forsee any plans for connecting to master.
See more ideas labeled with:
-
Databases | SQL Database
Submitted on
03-19-2025
02:40 AM
Submitted by
BobDuffyIRL
on
03-19-2025
02:40 AM
When we restore a Fabric SQLDB it changes the database names which break the ETL and all customers connecting to it. We then have to ge everyone globally to change the connection string, which means a restore has customer downtime of days. Can you fix this so that a restore keeps the original database name and doesnt break the connection string ? Ideally a restore shoudl restore "as was" unless we choose to restore to a different Artefact Name or workspace.
... View more
See more ideas labeled with:
-
Databases | SQL Database
Submitted on
02-27-2025
04:22 AM
Submitted by
garddolau
on
02-27-2025
04:22 AM

Tried using Fabric SQL database to hold the metadata tables for metadata driven ingestion. Fabric SQL Database is not supported as source in stored procedure activity in pipelines. We need to update log tables in our metadata db by using the stored procedure activity. Is adding Fabric SQL Database in stored procedure activity on roadmap soon? Without this option available Fabric SQL database is not a viable option to replace an Azure SQL DB at this time. Please prioritise this option, Fabric SQL database is available in the Data Pipeline lookup activity so hopefully not to much much effort to also add to stored procedure activity. Thanks
... View more
See more ideas labeled with:
-
Data Factory | Data Pipeline
-
Databases | SQL Database
-
Fabric platform
Submitted on
03-19-2025
02:50 AM
Submitted by
BobDuffyIRL
on
03-19-2025
02:50 AM
Currently when using SQLDB if we enter the server name / dns into SSMS or another tool it will fail as the connection defaults to master and the yser has no rights. We then have to manually add database, which is a GUID iso impossible to remember! Please allow the user(s) public rightsr in the master so that we can connect in SSMS and other tools and then select the database from pull down. This is how every other edition of SQL works!
... View more
We are going to clean up the database name, but we won't be allowing connection access to master.
See more ideas labeled with:
-
Databases | SQL Database
Submitted on
03-11-2025
08:00 AM
Submitted by
garddolau
on
03-11-2025
08:00 AM

Hi Team, Great to get the ability to create a SQL Database via API are you working on the ability to return the connection details? To make it more useful it would be great if we could get the connection details for the created database to (similar to how we can get in warehouse). ** Once completed can we update the offical documentation ASAP so the Terraform provided team can start using ** Return something like below: { "id": "5b218778-e7a5-4d73-8187-f10824047715", "displayName": "SQLDatabase1", "description": "A SQLDatabase description.", "type": "SQLDatabase", "workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229" "properties": { "serverFqdn": "dqjx2zrgh4uejnetrut54cdkau-g3353rbpoubuvclqhgoznhkmji.database.fabric.microsoft.com", "databaseName": "SQLDatabase1-b218778-e7a5-4d73-8187-f10824047715" }, } Thanks, Darren
... View more
If you don't see this available already, you should see it soon.
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-09-2024
06:18 AM
Submitted by
todd_chittenden
on
12-09-2024
06:18 AM
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.
... View more
We do plan to remove the GUID from the database name/url
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
11-21-2024
01:43 AM
Submitted by
Vojtech_Dolejsi
on
11-21-2024
01:43 AM
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and events during ETL loads.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-08-2024
09:46 PM
Submitted by
v-ehayama
on
12-08-2024
09:46 PM

Currently, the collation sequence for Microsoft Fabric SQL Database is set to SQL_Latin1_General_CP1_CI_AS, which means that creating tables or column names in Japanese or other languages will result in garbled characters. We have also confirmed that it is currently not possible to change the collation sequence in Microsoft Fabric SQL Database. On the other hand, the collation sequence for Microsoft Fabric warehouses is set to Latin1_General_100_BIN2_UTF8, which we have confirmed will not result in garbled characters. Therefore, we believe that if we could change the collation sequence for Microsoft Fabric SQL Database, it would be possible to set it to Latin1_General_100_BIN2_UTF8, which would help prevent garbled characters.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
01-10-2025
07:04 AM
Submitted by
rob_carrol1
on
01-10-2025
07:04 AM
We are working on a migration project to Fabric and need to combine data from inside a SQL Database with data in a Lakehouse then write it to another table in the database. Due to T-SQL compatibility issue with Data Warehouse, we want to use a Fabric SQL database for the Gold layer. For example: SELECT * FROM SilverLakehouseDeltaTable x JOIN GoldDatabaseSQLTable y ON y.id = x.id This should be part of a INSERT / UPDATE or MERGE such as: INSERT INTO AnotherGoldDatabaseSQLTable (Columns) SELECT * FROM SilverLakehouseDeltaTable x JOIN GoldDatabaseSQLTable y ON y.id = x.id The ability to read data from OneLake in a Fabric SQL database would solve this problem.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
01-13-2025
04:32 AM
Submitted by
rob_carrol1
on
01-13-2025
04:32 AM
It should be possible to query data in a Fabric Lakehouse directly in Fabric SQL database using T-SQL. For example I have the following scenario where I want to join data from a table in my Fabric SQL DB to a delta table in my lakehouse then insert the resultset into another table in my Azure SQL database: INSERT INTO AnotherGoldDatabaseSQLTable (Columns) SELECT * FROM SilverLakehouseDeltaTable x JOIN GoldDatabaseSQLTable y ON y.id = x.id This isn't currently possible with Fabric SQL Database.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
01-23-2025
05:40 AM
Submitted by
bob_duffy
on
01-23-2025
05:40 AM
It would really help with backwards compat and frustrations connecting in SSMS if Fabric SQLDB allowed users to connect to master. This adds 2 improvements 1) In this way we could connect to SSMS and then change DB afterwards , which is very much a mainstream practice. we understand telemetry shows that this is the No1 connection error from SSMS. 2) Currently some features such as dacpac, VS package export from SSMS and 3rd party schema compares break due to this issue.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-07-2024
10:51 AM
Submitted by
mark_lobbezoo
on
12-07-2024
10:51 AM
Within Fabric SQL databases you can cross-database query in the warehouse connection. However cross-database querying from one live SQL database to another is not possible. It would be great to have this possibility with 3-part names: select* from [sqldatabase].[dbo].[table_A] By getting this migrating from on-prem SQL server or an Azure managed instance to Fabric will be easier.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-09-2024
12:30 PM
Submitted by
BillBreitenbach
on
12-09-2024
12:30 PM
Currently, databases are randomly assigned to a pool of logical servers and there is not a way to group databases under same logical server name. Please allow us to see all the SQL databases listed under the same logical server name. It would be ideal to create one connection to the server name. This eventually would make cross-database querying on the same server possible as well .
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
02-01-2025
11:12 AM
Submitted by
jboarman
on
02-01-2025
11:12 AM
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.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-18-2024
08:37 AM
Submitted by
filip_olason
on
12-18-2024
08:37 AM
There is currently no way to control the scaling of an SQL DB. There should be a way to limit the database from scaling above a certain size. And / or a way to set a fixed cost/size (similar to DTU purchasing model).
... View more
We are aware of this limitation and the challenges it causes.
See more ideas labeled with:
-
Databases | SQL Database
-
Fabric platform
Submitted on
01-23-2025
05:35 AM
Submitted by
bob_duffy
on
01-23-2025
05:35 AM
When doing restore we always get a new database ID, Physical Name and SqlEndPoint, even if the database logical name is the same (eg restore over the top). This causes a massive increase in RTO as afer the restore all end points broke and configuration management had to be updated and re-tested. When doing a restore we need to have the ability to keep database exactly as it was, rather than always creating a clone. In a recent DR event it was 5 minutes to restore, but the 2 days before we stopped getting issues on end points and config change impact.
... View more
As per Strahinja's comment below - clarification would be helpful.
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-09-2024
01:36 PM
Submitted by
esatterfield
on
12-09-2024
01:36 PM
The transactional nature of Fabric SQL DBs means these are a great SaaS offering for application data. However, the lack of an option to support selective deployment in pipelines (e.g., deploy Table A and Table B but not Table C since it is a work-in-progress) means your solution deployments have to be all or nothing. This would also benefit Fabric DWs as well, but I'll take what I can get. 🙂
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
12-18-2024
10:08 AM
Submitted by
todd_chittenden
on
12-18-2024
10:08 AM
If you add a (preview) Azure SQL Database to your Fabric Workspace, it shows under it two items: SQL Analytics Endpoint and Semantic Model. Please add the SQL Endpoint as well. And while you are at it, make the whole list able to expand and collapse with "> / v " or + / - icons. This will go a long way to user interface improvements.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Submitted on
01-23-2025
05:48 AM
Submitted by
bob_duffy
on
01-23-2025
05:48 AM
We had a few incidents here replication either stopped completely after a data centre crash or had irrecoverable errors. In all cases we had to fully restore database or delete and start again. We need the following features to help support replication and have smoother recovery from failures Start replication on GUI and API Stop replication on GUI and by API (The existing SQLDB API works here for Fabric) Query replication state on GUI and by API Resync either one table or all tables on GUI or by API. These features would allow for recovery from issues without having to do full restores and reduce customers down time.
... View more
See more ideas labeled with:
-
Databases
-
Databases | SQL Database
Idea Statuses
- New 15,110
- Need Clarification 10
- Needs Votes 22,639
- Under Review 642
- Planned 269
- Completed 1,650
- Declined 223
Helpful resources
Latest Comments
- abhimani on: Key Pair authentication for the snowflake in power...
- kyle_mueller on: Quickly Identify Table Columns Used in Calculation...
-
Aala_Ali
on: Importing data (or drag and drop) from Fabric Lake...
- anic on: Enhancing Purview Glossary Integration with Power ...
- yeyu47 on: Deployment Pipeline roles
- giusepper11 on: Reintroduce Workspace Name visibility for Lakehous...
-
Koen_Verbeeck
on: Fabric REST API - Allow to specify a folder when c...
-
michaelu1
on: Scheduled refreshes were turned off after two mont...
-
anshulsharma on: Integrate Fabric Eventhouse with Azure AI Agent se...
- david-ri on: Add Key pair based authentication for Snowflake Co...
-
Power BI
38,820 -
Fabric platform
542 -
Data Factory
448 -
Data Factory | Data Pipeline
293 -
Data Engineering
276 -
Data Warehouse
188 -
Data Factory | Dataflow
156 -
Fabric platform | Workspaces
131 -
Real-Time Intelligence
126 -
Fabric platform | OneLake
124 -
Fabric platform | Admin
120 -
Fabric platform | CICD
91 -
Fabric platform | Capacities
68 -
Real-Time Intelligence | Eventhouse and KQL
61 -
Fabric platform | Governance
54 -
Real-Time Intelligence | Activator
52 -
Data Science
49 -
Fabric platform | Security
49 -
Data Factory | Mirroring
38 -
Databases | SQL Database
32 -
Fabric platform | Support
32 -
Real-Time Intelligence | Eventstream
31 -
Fabric platform | Data hub
28 -
Databases
22 -
Data Factory | Apache Airflow Job
3 -
Fabric platform | Real-Time hub
3 -
Product
2
We are reviweing this but no dates to share yet.