At the moment this feature is a beta update. You would need to have Microsoft Excel installed and Consumer subscription licenses. In this article, Micheal Olafusi gives us a sneak-peek into Power Query in Excel for Mac. If Unity Catalog is enabled for your workspace, select a catalog before you select a schema and a table.Is there anything you have seen someone do in Excel and have always wondered how? How about Power Query in Excel For Mac Select the Databricks data to query from the Power BI Navigator. After the success message appears, exit your browser and return to Power BI Desktop. A browser window opens and prompts you to sign in with your IDP. Personal Access Token: Enter your personal access token. If you cannot log in by using your Databricks username and password, try using the Personal Access Token option instead. Username and password authentication may be disabled if your Databricks workspace is enabled for single sign-on (SSO). Username / Password: Enter your Databricks username and password. For information about the difference between Import and DirectQuery, see Use DirectQuery in Power BI Desktop. Select the Databricks data to query from the Power BI Navigator.Īlthough the connector name is Azure Databricks, it works with Databricks on AWS.ĭatabricks (Beta), if you authenticate using OAuth. If you cannot log in using your Databricks username and password, try using the Personal Access Token option instead. Username and password authentication might be disabled if your Databricks workspace is enabled for single sign-on (SSO). Username / Password: Enter your Databricks username (typically your email address) and password.

Personal Access Token: Enter your Databricks personal access token. In Power BI Desktop, enter your authentication credentials: Open the downloaded connection file, which starts Power BI Desktop. If your selected persona is Databricks SQL, choose a SQL warehouse. If your selected persona is Data Science & Engineering or Databricks Machine Learning, choose a cluster or SQL warehouse. In the Connect to partner dialog, for Compute, choose the name of the Databricks compute resource that you want to connect. Make sure your Databricks account, workspace, and the signed-in user meet the requirements for Partner Connect.

You can use Databricks Partner Connect to connect a cluster or SQL warehouse with Power BI Desktop in just a few clicks.

Connect to Databricks from Microsoft ExcelĬonnect to Power BI Desktop using Partner Connect.

Use power bi on mac