Skip to main content
Home

Welcome to Microsoft Fabric Ideas

1-10 of 275 results

Clear filters
Vote 90
David Purdy's profile image

David Purdy on 2023-06-29 18:27:30

Synapse

Add support for identity columns in Fabric warehouses.

Identity columns are a common method for generating surrogate keys in data warehousing scenarios implemented on SQL Server. By adding support for identity columns in Fabric, users could migrate their warehouse workloads from SQL Server to Fabric, without having to make drastic changes to thei...

Planned

Peri Rocha (administrator)

Thanks for your feedback! This feature is currently planned for 2024. 

UPDATE: while we're working to deliver this, if you currently need an alternative to IDENTITY columns you can use this workaround documented by our team: Generate unique identifiers in a warehouse table in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Vote 78
Vasantha Silvary's profile image

Vasantha Silvary on 2023-05-26 01:17:06

Synapse

Providing Azure Key Vault Access in Microsoft Fabric

if we get an option to connect to Azure KeyVault in Microsoft Fabric in Synapse data engineering through linked Service , We can retrieve values from keyvault which are sensitive in Nature.

Under Review

Administrator

This ask is under internal review. Stay tuned for updates.

Vote 76
Sam Debruyn's profile image

Sam Debruyn on 2023-06-18 15:38:49

Synapse

Support for nested WITH statements

TL;DR: nested WITH statements are supported in all modern data warehouses, lakehouses, and database engines except for Fabric & T-SQL products. This makes the usage of SQL templating engines unnecessarily complex.Fabric supports regular WITH statements like the following:...

Planned

Mariya Ali (administrator)

Thanks for your feedback. We are reviewing the support for Nested WITH statements.

Vote 28
Derek Williams's profile image

Derek Williams on 2024-01-06 03:39:33

Synapse

Lakehouse Recovery or Restore Points

Lakehouses, and more importantly the data inside them, are not recoverable if the the lakehouse is deleted. There is also no way to recover a prior lakehouse if the data needs to be rolled back to a previous state. BCDR was recently released but is only for capacity disaster ...

Under Review

Ted Vilutis (administrator)

We are evaluating this idea and its timeline along with other priorities. Your comments and votes will help us plan and design the feature. Thank you for your feedback! 

Vote 29
Ryoma Nagata's profile image

Ryoma Nagata on 2023-12-09 01:59:51

Synapse

Shared Spark Cluster

Users within the same workspace can utilize the same launched Spark Cluster. This eliminates the need for users to wait for the startup time of Spark, and also prevents excessive CU consumption caused by launching multiple clusters. This is different from the Hi-concurrency pool, which aims to...

Planned

Administrator

Thamk you for sharing this idea. We do have this in our roadmap of extending the sharing scope across multiple users as part of High Concurrency mode. 

Vote 40
Michal Mlaka's profile image

Michal Mlaka on 2023-06-06 10:41:07

Synapse

Organize tables in the Lakehouse

Please enable schemas in the Lakehouses.Publish some referential architecture how to organize Lakehouse resources in bronze/silver/gold arch. (raw/..)Publish referential architecture how to organize Lakehouse dev/test/sandbox ... resources in OneLake architecture.<...

Planned

Ted Vilutis (administrator)

This feature is in our roadmap. Please stay tuned. We will share more details as they become available.

Vote 48
Sandeep Pawar's profile image

Sandeep Pawar on 2023-05-29 15:04:11

Synapse

PowerShell Notebook Kernel

Please make PowerShell kernel available in Fabric notebook. PowerShell is used by Power BI and Azure users for calling APIs, administration and automation. This will greatly help with refreshing artifacts, retrieving metadata and monitoring artifacts. Notebooks can then be used standalo...

Under Review

Administrator

PowerShell Notebook kernel is under review.

Vote 44
Christoph Mettler's profile image

Christoph Mettler on 2023-05-30 11:45:19

Synapse

extent storage capacity of varchar(8000) to varchar(max)

The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and store them across multiple text fields or in separate tables is unnecessarily cumbersome.da...

Planned

Bogdan Crivat (administrator)

We're working on this. We'll share details as soon as we have a clear timeline.

Vote 32
Erwin de Kreuk's profile image

Erwin de Kreuk on 2023-10-31 07:18:38

Synapse

Having the ability to use a view created in a Lakehouse in a Spark Notebook.

Having the ability to use a view created in a Lakehouse in a Spark Notebook.Currently this is not possible and you will get an exception, table or view not found.As an example. you want to combine data from a Silver Layer from different ERP systems in 1 view to create your Gold L...

Under Review

Ted Vilutis (administrator)

We are evaluating this idea and its timeline along with other priorities. We are looking to enable Views in Lakehouse Explorer as it's not yet supported. Your comments and votes will help us plan and design the feature. Thank you for your feedback! 

Vote 43
Christian Harrington's profile image

Christian Harrington on 2023-06-19 16:30:26

Synapse

Fabric Warehouse table support for Primary Key enforced

Warehouse tables don't support Primary Key enforced right now.With this limitation we cannot use apps writing to the database using a primary key.The scenario we are trying to use is PowerApps writing to Fabric Warehouse. But there could be many others, any scenario requir...

Needs Votes