Veuillez entrer vos informations personnelles pour vous abonner au blog Microsoft Fabric.

Merci de vous être abonné au blog Microsoft Fabric. Vous recevrez des notifications par courrier électronique lorsque nous publierons de nouveaux messages.

Microsoft Fabric Updates Blog

  1. Mises à jour
  2. Jovan Popovic

Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)

Fabric Data Warehouse now supports the ANY_VALUE() aggregate, making it easier to write readable, efficient T-SQL when you want to group by a key but still return descriptive columns that are functionally the same for every row in the group. What is ANY_VALUE()? ANY_VALUE() is an aggregate or analytic function that returns an arbitrary value … Continue reading “Use ANY_VALUE() for simpler grouping of results in Fabric Data Warehouse (Generally Available)”

Working with unstructured text in Fabric Data Warehouse with built-in AI functions (Preview)

Data warehouses traditionally focus on structured and semi-structured data. Free-form text such as notes, logs, or comments was difficult to process in data warehousing scenarios without external components. Microsoft Fabric Data Warehouse is opening new scenarios in modern data warehousing by enabling you to work with unstructured text using new AI capabilities. We are introducing … Continue reading “Working with unstructured text in Fabric Data Warehouse with built-in AI functions (Preview)”

Large string and binary values in Fabric Data Warehouse and SQL analytics endpoint for mirrored items (Generally Available)

Co-authored with: Ancy Philip Fabric Data Warehouse and SQL analytics endpoints for mirrored items now support large string and binary data using VARCHAR(MAX) and VARBINARY(MAX) types. Large string or binary values in Data Warehouse In Fabric Data Warehouse, this enhancement allows you to ingest, store, process, and analyze large descriptive text, logs, JSON, or spatial … Continue reading “Large string and binary values in Fabric Data Warehouse and SQL analytics endpoint for mirrored items (Generally Available)”

Ingest files into your Fabric Data Warehouse using the OPENROWSET function

Data ingestion is one of the most important actions in the Data Warehouse solutions. In Microsoft Fabric Data Warehouse, the OPENROWSET function provides a powerful and flexible way to read data from files stored in Fabric OneLake or external Azure Storage accounts. Whether you’re working with Parquet, CSV, TSV, or JSONL files, the OPENROWSET function … Continue reading “Ingest files into your Fabric Data Warehouse using the OPENROWSET function”