Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
arkiboys
Advocate II
Advocate II

dataflow

Hello,

In azure ADF, previously I created a dataflow which reads a .csv sitting in the raw container of a storage account and then does a bit of transformations and then saves the data as delta parquet files into the curated container.

Now I would like to do something similar but in fabric. 

What is the way to do this in fabric? I ask because I see in the lakehouse an option to store Files. So I tried it out. In Files I uploaded the .csv

perhaps in fabric dataflow I can read the .csv file and do transformation or maybe in Files folder I convert the .csv file to table?...

Any guidance please?

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello again @arkiboys ,

Thanks for using Fabric Community.
Fabric doesn't directly support dataflows like Azure Data Factory (ADF) for data transformations.
In Fabric we have Data Flow Gen 2 inorder to do complex transformations from UI.

Docs to refer - Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft Learn

You can also also use Notebooks with pyspark to do these tranformations.

If you are looking to load csv file to table (without any transformations), you can simply upload the file and can use the option - Load to Tables in Lakehouse.

Hope this is helpful. Do let me know incase of further queries.



View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hello again @arkiboys ,

Thanks for using Fabric Community.
Fabric doesn't directly support dataflows like Azure Data Factory (ADF) for data transformations.
In Fabric we have Data Flow Gen 2 inorder to do complex transformations from UI.

Docs to refer - Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft Learn

You can also also use Notebooks with pyspark to do these tranformations.

If you are looking to load csv file to table (without any transformations), you can simply upload the file and can use the option - Load to Tables in Lakehouse.

Hope this is helpful. Do let me know incase of further queries.



Anonymous
Not applicable

Hi @arkiboys ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Anonymous
Not applicable

Hi @arkiboys ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.