Connecting Power BI to Databricks SQL
Databricks SQL provides built-in connectors for Power BI users to connect to objects in Databricks SQL. Power BI users can now connect to a SQL endpoint to get a list of all tables and can connect using the import or direct query mode.
In this recipe, you will learn how to connect to a SQL endpoint from Power BI.
Getting ready
Before starting the recipe, ensure you have executed both of the following notebooks. The following notebook creates the required tables on which we can build our visualizations and dashboard. You need to ensure you download the latest version of Power BI Desktop:
- https://github.com/PacktPublishing/Azure-Databricks-Cookbook/blob/main/Chapter07/7.1-End-to-End%20Data%20Pipeline.ipynb
- https://github.com/PacktPublishing/Azure-Databricks-Cookbook/blob/main/Chapter06/6_1.Reading%20Writing%20to%20Delta%20Tables.ipynb
You can go through the following link which has the requirements for connecting Power...
