CSV file upload to Delta table for Power BI reporting

Microsoft Fabric Lakehouse is a data architecture platform for storing, managing, and analyzing structured and unstructured data in a single location.

In this tutorial you learn to:

• Upload a CSV file to a Lakehouse
• Convert the file to a Delta table
• Generate a semantic model and create a Power BI report

Create a Lakehouse and get a CSV file ready

1. In Microsoft Fabric, select Synapse Data Engineering.

2. Make sure that you're in your desired workspace, or select or create one.

3. In the Home page, select Lakehouse.

   

4. Enter name of your Lakehouse.

5. Select Create.

6. Download the "Taxi Zone Lookup Table" CSV file from the TLC Trip Record Data website, and save to a location in your computer.

Upload a CSV file to the Lakehouse

1. Create the TaxiData folder under the Files section of your Lakehouse.

2. Upload the file to the folder, by using the Upload file item in the folder contextual menu.

3. Once uploaded, select the folder to see its content.

4. Rename the file to remove special characters, in this example, remove the '+' character. To see the full list of special characters, read the Load to Delta Lake tables article.

   

Load the file to a Delta table

1. Right-click or use the ellipsis on the CSV file to access the contextual menu. Select Load to Tables and choose the New table option.

2. The load to tables user interface shows up with the suggested table name. Real time validations on special characters apply during typing.

3. Select Load to execute the load.

4. The table now shows up in the lakehouse explorer, expand the table to see the columns and its types. Select the table to see a preview.

   

Note

If the table already exists, different load mode options are shown. Overwrite will drop and recreate the table. Append will insert all CSV content as new data. For an in-depth guide on the Load to Tables feature, read the Load to Tables article.

Generate a semantic model and create a Power BI report

1. Select New Power BI semantic model on the Lakehouse ribbon.

2. Select the table to be added to the semantic model, select the Confirm button.

3. With semantic model editing, you are able to define relationships between multiple tables, and also apply data types normalization and DAX transformations to the data if desired.

4. Select New report on the ribbon.

5. Use the report builder to design a Power BI report.

   

Related content

• Load to Delta Lake tables
• What is Delta Lake?