Both features rely on Databricks SQL which is only available in the Databricks Premium Plan. An Azure Databricks Cluster or Databricks SQL WarehouseĪdditionally, if you want to use features such as Partner Connect or you want to enable incremental refresh in Power BI on Databricks tables you will need a Premium Plan for your Azure Databricks account.Access token for Databricks or AAD access to Databricks.Installation of Power BI Desktop of 2.85.681.0 or above.The following prerequisites are needed to be able to connect Power BI to Databricks. We will describe how Power BI can connect directly to the delta tables in Databricks. In this article, we will focus on Databricks Lakehouse, which offers a Lakehouse implementation based on the delta format. Recently, there started to arise different ways of providing a direct connection from front-end tools to the Data Lake. This often caused duplication of the data which is illustrated in the schema below. A Data Warehouse was needed to expose your data in the Data Lake to front-end tools like Power BI.
This was not possible (not in a performant way anyways) a couple of years ago. One of the required features of a Lakehouse is that BI tools can connect directly to the data in the Data Lake.
Briefly explained, all your data of your company is kept in the Data Lake without a need for a Data Warehouse, but with the advantages and features that were typically associated with traditional Data Warehouses in the past. Over the last months, the concept of a Lakehouse has become more prevalent within organizations.
0 kommentar(er)
