Welcome to Microsoft Fabric Ideas
1-10 of 69 results
Sam Debruyn on 2023-06-18 15:38:49
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:...
Mariya Ali (administrator)
Thanks for your feedback. We are reviewing the support for Nested WITH statements.
David Purdy on 2023-06-29 18:27:30
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...
Peri Rocha (administrator)
Thanks for your feedback! We are currently planning for this feature.
Christoph Mettler on 2023-05-30 11:45:19
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...
Bogdan Crivat (administrator)
We're working on this. We'll share details as soon as we have a clear timeline.
Bob Duffy on 2023-06-29 09:17:14
Add OPENXML support to Fabric DataWarehouse
We have OPENJSON support which is very useful when we have Json in data tables.However many vendors and sources today use XML for extensibility and not JSON. Lack of OPENXML is limiting our ability to migrate from SqlDBEngine to Fabric and prevents in db querying of XM...
Christoph Mettler on 2023-06-08 11:29:27
support openrowset/polybase
Data providers typically deliver data in formats such as parquet, JSON, or CSV. In traditional data warehouse scenarios, these files often land in a persistent staging area. Many organize these staging folders in a structured manner such as year/month/week/day. Currently, these files need to b...
Administrator
Can you share more details about your scenarios and if Lakehouse Shortcuts would work for you?
Bob Duffy on 2023-11-17 10:08:06
Add support for SSDT Schema Compare for DW and LH
Current Visual Studio supports All editions of SQL except Fabric.This is an essential tool quick ad hoc schema compares.Please consider adding support to SSDT for Fabric artefacts so that we can use SSDT.https://learn.microsoft.com/en-us/sql/ssdt/how-...
Thomas Martens on 2023-08-07 15:30:12
Azure Synapse Link for Oracle
Like the Azure Synapse Link for SQL Server 2022, an Azure Synapse Link for Oracle 19/21 will add tremendous value to the MSFT Fabric Analytics Platform, as many Oracle databases are running.An easy way to "replicate" data into the realm of Synapse/Fabric is reducing the required skillse...
Harrington Harrington on 2023-06-19 16:30:26
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...
Pascal Couture on 2023-06-06 10:43:57
Microsoft Fabric - Lakehouse Explorer - Add a last refresh date & time on the tables
Please add a "Last Refresh Date & Time" to the "..." options of the Tables explorer in the Microsoft Fabric. Would give us the ability to see if the table got refreshed through a data flow v2 or from the Files.
Charles Webb (administrator)
Can you tell us more about why this is important to you, and what you want to do with this information?
Toby Riley on 2023-06-05 10:42:23
Support Name Column Mapping Mode in SQL Endpoints for Lakehouse
Name Column Mapping Mode in SQL Endpoints for Lakehouse is not supported so tables with unsupported columns names (spaces, special chars, capitalization) do not work.To re-create the behaviour.1. Create a table in Databricks with column mapping enabled.<...
Charles Webb (administrator)
We're working on this functionality along with deletion vectors support. Stay tuned to the blog for updates!