Edit

Share via

CSV file upload to Delta table for Power BI reporting

  • Article

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. Sign into the Microsoft Fabric portal. Select Data Engineering from the workload switcher in the bottom-left corner.

  2. Make sure that you're in your desired workspace. Open your existing workspace or create a new one.

  3. From the workspace, select New item page, and select Lakehouse.

    Screenshot showing new lakehouse dialog.

  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.

    Animated image showing upload CSV and CSV renaming.

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.

    Animated image showing load to table and table 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.

    Animated image showing semantic model and power bi report generation.

Related content