Connect to an Impala database in Power BI Desktop

In Power BI Desktop, you can connect to an Impala database and use the underlying data just like you can with any other data source in Power BI Desktop.

Connect to an Impala database

To connect to an Impala database, take the following steps:

  1. Select Get Data from the Home ribbon in Power BI Desktop.

  2. Select Database from the categories on the left. Then you see Impala.

    Get Data

  3. In the Impala window that appears, type or paste the name of your Impala server into the box. Then select OK. You can Import data directly into Power BI or you can use DirectQuery. Learn more about using DirectQuery.

    Impala window

  4. When prompted, enter your credentials or connect anonymously. The Impala connector supports Anonymous, Basic (user name + password), and Windows authentication.

    Impala connector


    After you put in your user name and password for a particular Impala server, Power BI Desktop uses those same credentials in subsequent connection attempts. You can modify those credentials by going to File > Options and settings > Data source settings.

  5. After you connect, a Navigator window appears and displays the data that's available on the server. Choose elements from this data to import and use in Power BI Desktop.

    Navigator window

Considerations and limitations

There are a few considerations and limitations to keep in mind with the Impala connector:

  • The Impala connector is supported on the on-premises data gateway, using any of the three supported authentication mechanisms.
  • The Impala connector uses the Impala driver, which limits the size of string types to 32K by default.

Next steps

There are many different data sources that you can connect to by using Power BI Desktop. For more information about data sources, check out the following resources: