在 Power BI Desktop 中连接到 Amazon RedshiftConnect to Amazon Redshift in Power BI Desktop

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

连接 Amazon Redshift 数据库Connect to an Amazon Redshift database

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

在出现的 Amazon Redshift 窗口中,将你的 Amazon Redshift 服务器和数据库名称键入或粘贴到框中。In the Amazon Redshift window that appears, type or paste the name of your Amazon Redshift server and database into the box. “服务器”场中的用户可用以下格式指定端口:ServerURL:PortAs part of the Server field, users can specify a ort in the following format: ServerURL:Port

出现提示时,输入你的用户名和密码。When prompted, put in your username and password.

连接成功后,将会出现“导航器”窗口,并显示服务器上可用的数据。你可以从这些数据中选择要在 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.

在“导航器”窗口中选择后,就可以“加载”或“编辑”数据。Once you make selections from the Navigator window, you can either Load or Edit the data.

  • 如果选择“加载”数据,系统将提示你使用“导入”或“DirectQuery”模式来加载数据。If you choose to Load data, you'll prompted wither to use Import or DirectQuery mode to load the data. 有关详细信息,请参阅 DirectQuery 说明文章For more information, check out this article that explains DirectQuery.
  • 如果选择“编辑”数据,“查询编辑器”将出现在可对数据应用各种转换和筛选器的位置,其中很多应用于基础 Amazon Redshift 数据库本身(如果支持)。If you select to Edit the data, Query Editor appears where you can apply all sorts of transformations and filters to the data, many of which are applied to the underlying Amazon Redshift database itself (if supported).

后续步骤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: