在 Power BI Desktop 中连接到 Impala 数据库Connect to an Impala database in Power BI Desktop

在 Power BI Desktop 中,你可以连接到 Impala 数据库,并以 Power BI Desktop 中使用其他所有数据源相同的方式使用基础数据。In Power BI Desktop, you can connect to an Impala database and use the underlying data just like any other data source in Power BI Desktop.

连接到 Impala 数据库Connect to an Impala database

若要连接到 Impala 数据库,请从 Power BI Desktop 中的“主页”功能区选择“获取数据”。To connect to an Impala database select Get Data from the Home ribbon in Power BI Desktop. 在左侧的类别中选择“数据库”,然后将看到 Impala。Select Database from the categories on the left, and you see Impala.

在出现的 Impala 窗口中,将你的 Impala 服务器名称键入或粘贴到框中,然后选择“确定”。In the Impala window that appears, type or paste the name of your Impala server into the box, and select OK. 请注意,可以选择将数据直接导入到 Power BI 中,或使用 DirectQueryNote that you can choose to Import data directly into Power BI, or you can use DirectQuery. 可以了解有关使用 DirectQuery 的详细信息。You can learn more about using DirectQuery.

当收到提示时,输入你的用户名和密码,或匿名连接 - 两种方式均受支持。When prompted, put in your username and password, or connect anonymously - either is supported.

备注

输入用户名和密码以连接特定 Impala 服务器后,Power BI Desktop 在后续连接尝试中会使用这些相同的凭据。Once you put in your username 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.

连接成功后,将会出现“导航器”窗口,并显示服务器上可用的数据。你可以从这些数据中选择要在 Power BI Desktop 中导入和使用的一个或多个元素。Once you successfully connect, a Navigator window appears and displays the data available on the server, from which you can select one or multiple elements to import and use in Power BI Desktop.

注意事项和限制Considerations and Limitations

对于 Impala 连接器,需要牢记以下限制和注意事项:There are a few limits and considerations to keep in mind with the Impala connector:

  • 未来计划包括使用 Power BI Gateway 启用刷新支持。Future plans include enabling refresh support using the Power BI Gateway.

后续步骤Next steps

你可以使用 Power BI Desktop 连接到各种数据。There are all sorts of data you can connect to using Power BI Desktop. 有关数据源的详细信息,请参阅下列资源:For more information on data sources, check out the following resources: