Forum Discussion
save data in excel
hello,
in fabric dataflow, after some transformations, I have got the data.
Now I would like to save this data as excel.
How do I do this?
thanks
Hi Anonymous
I am adding the code snippet here:import pandas as pd df = spark.sql("SELECT * FROM lakehouse_1.customers_1000") df1= df.toPandas() df1.to_excel('abfss://[email protected]/lakehouse_1.Lakehouse/Files/sample.xlsx')
Just replace with the abfss path of your lakehouse files folder.
Hope this helps.
6 Replies
Hi Anonymous
Thanks for using Fabric Community.
Unfortunately, Fabric Dataflow (Gen2) itself doesn't have a built-in functionality to directly save the transformed data as an Excel file. However, you can achieve this by integrating Dataflow with Notebooks:
1) Give the destination as lakehouse in Dataflow Gen2 and publish the Dataflow . This will create a new table in your lakehouse.
2) Create a new notebook and run the below code:
3) The excel file will be created in Lakehouse files section.
4) You can also download this file into your local desktop using Onelake explorer.
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
5) Download the latest version of Onelake explorer and sync the Lakehouse.
Hope this helps. Please let me know if you have any further questions.Hi Anonymous
I am adding the code snippet here:import pandas as pd df = spark.sql("SELECT * FROM lakehouse_1.customers_1000") df1= df.toPandas() df1.to_excel('abfss://[email protected]/lakehouse_1.Lakehouse/Files/sample.xlsx')
Just replace with the abfss path of your lakehouse files folder.
Hope this helps.