Connecting a Databricks Delta Lake table to Power BI
Delta Lake databases are commonly used to store processed data in Delta Lake tables, which is then ready to be consumed by reporting-layer applications such as Power BI. Delta Lake tables are best suited for handling analytic workloads from Power BI, as Delta Lake tables use Parquet files as storage, which offer optimal performance for analytic workloads.
In this recipe, we will use Power BI Desktop, connect to a Delta Lake table, and build a simple report in Power BI.
Getting ready
Create a Databricks workspace and a cluster as explained in the Configuring the Azure Databricks environment recipe.
Download the latest version of Power BI Desktop from https://powerbi.microsoft.com/en-us/downloads/ and install Power BI Desktop on your machine.
How to do it…
Perform the following steps to connect a Delta Lake table to a Power BI report and create visualizations:
- Log in to the Databricks portal and click...
