Microsoft Fabric Updates Blog

Optimizing Permissions with OneLake Security ReadWrite Access

Many data teams face the same challenge: balancing the need for open collaboration with the responsibility of protecting sensitive information. As organizations grow, data often lives across multiple domains—some containing critical or confidential datasets—while partner teams may only need access to a subset of that information. Until recently, maintaining this balance often meant trade-offs. Teams … Continue reading “Optimizing Permissions with OneLake Security ReadWrite Access”

Bridging the Gap: Automate Warehouse & SQL Endpoint Deployment in Microsoft Fabric

Deployment Challenges While Solutions Are in Development Microsoft Fabric has revolutionized data analytics with its unified platform, but deploying complex architectures with cross-dependencies remains a significant challenge for organizations. The good news is that the Microsoft Fabric team is actively working on native warehouse deployment capabilities with DacFx, cross-item dependency resolution, and cross-warehouse reference support. … Continue reading “Bridging the Gap: Automate Warehouse & SQL Endpoint Deployment in Microsoft Fabric”

Simplifying Data Ingestion with Copy job – Replicate data from Dataverse through Fabric to multiple destinations

Copy job is the recommended approach in Microsoft Fabric Data Factory for moving data from any sources to any destinations in a simplified and efficient way—whether you’re transferring data across clouds, from on-premises systems, or between services. With native support for multiple delivery patterns, including bulk copy, incremental copy, and change data capture (CDC) replication, … Continue reading “Simplifying Data Ingestion with Copy job – Replicate data from Dataverse through Fabric to multiple destinations”

Manage environment configuration in Fabric User data functions with variable libraries 

Data Engineers working with Microsoft Fabric often need to manage environment-specific configurations, including the modification of Lakehouse names, file paths, or schema names for development, testing, and production environments. In this scenario, you would want to avoid hard coding this information. This is where variable libraries in Fabric can help data engineers manage their environment configuration when working with Fabric User data … Continue reading “Manage environment configuration in Fabric User data functions with variable libraries “

OPENROWSET and External Tables for Fabric SQL Databases (Preview)

Data Virtualization (Preview) for Fabric SQL Databases, enable you to query, analyze, and ingest OneLake data (CSV, Parquet, JSON) without moving or duplicating it. Data Virtualization brings to Fabric SQL Database the same set of capabilities already available on Azure SQL Database, Azure SQL Managed Instance and SQL Server, customers can now use OPENROWSET and … Continue reading “OPENROWSET and External Tables for Fabric SQL Databases (Preview)”