Introduction
Welcome to Excel Jet Consult blog post. In this blog, we will continue the exploration of the different objects in the Microsoft Fabric. Let’s get started.
What is Dataflow?
An ETL tool, Microsoft Fabric Dataflow is a self-service, cloud-based, data preparation technology that allows users to move and transform data using a visual interface. It is part of the Microsoft Fabric platform and provides a way to create, execute, and manage data transformation processes using Power Query online. Users can get data from different sources, perform transformative tasks as desired and then load to destination for further use.
How to Get Started Creating a Dataflow
In this demostrative part, we will connect to a text file that contains sales dataset using the Dataflow Gen2. The screenshot below shows the text dataset we want to connect to:
To switch to the Data Factory, click on the Microsoft Fabric icon located at the bottom left of the screen and select Data Factory as seen below:
Next, we created a workspace by clicking on the Workspaces and selecting New Workspace. The workspace is name: First_DataFlow
Click on Apply
In the screenshot below, we can see the Dataflow Gen2 (Preview). That allows us to access the ETL tool to connect to data from different source.
Next, we have the Power Query online open.
To connect to the txt Sales_Record file, click on Import From TXT/CSV
In the Connect to data source, click on Upoload File and brows through the file located. In the screenshot below, we can see that the file is successfully uploaded
Click on Next
In the screenshot below, we have the data preview
Click on Next
And there we go, we have the dataset in the Dataflow Gen2. We can perform required transformative tasks and load the data to the destination such as Laekhouse or Warehouse
See you in the next blog