DownLoad CSV files from Delta Lake

[Madalian]

We have around 1800 tables in Parq format (Delta Lake). These 1800 tables are very big, we have all these 1800 tables are converted into tables. But we have a requirement that, we need to download in CSV. (from PowerBI / any other reporting tool). Customer want to download full set of tables. I tried following ways.

1. Created paramterized Notebook to filter table and download from result set.

This method is not so liking by users.

Thanks

[Kaniz_Fatma]

Hi @Madalian, In Power BI, you can directly export data from a visualization to a CSV file. Here’s how:

• Select the visual you want to export data from.
• Click the three dots (More options) and choose “Export data.”
• Specify a location for the CSV file and save it.

• Since you mentioned that you’ve already converted the Parquet tables into tables, you can use Python scripting to export the data to CSV.
  • Write a Python script that reads the Parquet files and converts them to CSV.
  • Execute the script to generate CSV files.
  • Load these CSV files into Power BI.

[jose_gonzalez]

@Madalian did you have time to check Kaniz's response? does this help or you still need help? please let us know

[Madalian]

Dear Kaniz,

Thank you. one doubt 1) converting tables data into CSV and saving again one more of storage layer.

IS there any way on fly we can convert these tables into CSV's. and export into PowerBI? and again i see in powerBI has limitations around > 5 gb downloads. we have some tables 10 GB +.

Thanks