Microsoft Fabric Updates Blog

Introducing Data Factory in Microsoft Fabric

See Arun Ulagaratchagan’s blog post to read the full Microsoft Fabric preview announcement.

 

As organizations work through their digital transformation journeys, they are awash with data that they need to bring together to meet their analytics needs. To do this, they need to seamlessly access data from a diverse set of data sources, reshape and transform the data to the right format, and load the data into a data store like a lakehouse or data warehouse, where the data can support their analytics needs. In addition, companies are looking to stitch together different data activities (e.g., running a notebook, a stored procedure, SQL script, and more) and orchestrate specific data workflows.

 

Today, we are unveiling Data Factory in Microsoft Fabric, bringing together the best of Power Query and Azure Data Factory into a single, modern data integration experience which empowers both data and business professionals with capabilities to ingest and transform data as well as orchestrate data workflows. Our goal is to empower everyone to be able to connect to diverse data sources and bring that data to where it can best help you derive insights for better business decisions.

 

Whether you’re a citizen or professional developer, Data Factory enables you to develop enterprise-scale data integration solutions with next-generation dataflows and data pipelines. 

 

Data Factory in Fabric empowers you with: 

    • Seamless connectivity to more than 170+ data stores (including on-premises data sources, cloud databases, analytical platforms, line of business applications, and more)
    • Next-generation Power BI dataflows is now available as part of Data Factory in Fabric, providing 300+ out-of-the box data transformations, including AI transformations, and scalable data flows that run on Fabric compute. In addition, you can output the transformed data into various data destinations. 
    • Data pipelines in Fabric is an evolution of Azure Data Factory pipelines which provides you with a rich set of integration capabilities. In addition, the copy assistant enables you to jumpstart any copy task from data sources to data destinations.
    • Built-in AI enables you to accelerate and automate common data integration tasks.

For example, you might need to extract data from an unstructured data source like a web page or a text file without a well-defined format. With the help of AI, you can now use Data Factory to analyze examples you give on values you want to extract. Then, the powerful AI capabilities underneath the hood learn from the examples and create the Data Factory dataflows to extract just the data you need.

 

Watch an overview of Data Factory in Microsoft Fabric:

Explore how our customers and partners are already using Data Factory in Microsoft Fabric  

 

Hitachi Solutions 

Hitachi Solutions provides consulting services to help customers migrate their data systems into Microsoft Fabric. Their global team of IT professionals has extensive expertise using Data Factory in Fabric to seamlessly integrate data from multiple sources.

“The Data Factory experience in Microsoft Fabric has surpassed our data and analytics needs by equipping our customers with industry-leading data orchestration capabilities in an elegant, easy-to-use, code-free experience.”

Simon Nuss, Vice President of Data & Analytics, Hitachi Solutions

 

Watch the team at Hitachi Solutions using Data Factory with Fabric:

  

Delphix 

Delphix has a strong track record of delivering powerful data compliance capabilities to enterprises across industries to address their privacy mandates and cybersecurity requirements. Delphix is partnering with Microsoft to bring their proven technology to the Microsoft Fabric platform with Delphix Compliance Services for Data Factory. 

 “In collaborating with Microsoft to bring our multi-cloud data masking solution to Microsoft Fabric, Delphix is proud to deliver a comprehensive way to de-risk the cloud while accelerating the path from data to transformation.”  

Jedidiah Yueh, Delphix Founder and CEO

 

Learn more about the Delphix Compliance Services for Data Factory.

  

Get started with Microsoft Fabric

Microsoft Fabric is currently in preview. Try out everything Fabric has to offer by signing up for the free trial—no credit card information required. Everyone who signs up gets a fixed Fabric trial capacity, which may be used for any feature or capability from integrating data to creating machine learning models. Existing Power BI Premium customers can simply turn on Fabric through the Power BI admin portal. After July 1, 2023, Fabric will be enabled by default for all Power BI tenants. 

 

Sign up for the free trial. For more information read the Fabric trial docs.

 

Learn more about Data Factory in Fabric at the following Build 2023 sessions:

  

Other resources 

If you want to learn more about Microsoft Fabric, consider:   

Related blog posts

Introducing Data Factory in Microsoft Fabric

October 7, 2024 by Alex Lin

Introducing Managed VNet Support for Fabric Eventstream! By creating a Fabric’s Managed Private Endpoint, you can now securely connect Eventstream to your Azure services, such as Azure Event Hubs or IoT Hub, within a private network or behind a firewall. This integration ensures your data is securely transmitted over a private network, enabling you to … Continue reading “Secure Data Streaming with Managed Private Endpoints in Eventstream (Preview)”

October 4, 2024 by Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”