在 Power BI Desktop 中连接到 Google BigQuery 数据库Connect to a Google BigQuery database in Power BI Desktop

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

连接到 Google BigQueryConnect to Google BigQuery

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

获取 Google BigQuery 的“数据”对话框

在显示的 Google BigQuery 窗口中,登录到 Google BigQuery 帐户并选择“连接” 。In the Google BigQuery window that appears, sign in to your Google BigQuery account and select Connect.

登录到 Google BigQuery

登录后,将看到以下窗口指示已经过身份验证。When you're signed in, you see the following window indicated you've been authenticated.

已登录到 Google

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

来自 Google BigQuery 的数据

注意事项和限制Considerations and Limitations

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

  • Power BI Desktop 和 Power BI 服务中提供了 Google BigQuery 连接器。The Google BigQuery connector is available in Power BI Desktop and in the Power BI service. 在 Power BI 服务中,可以使用从 Power BI 到 Google BigQuery 的云到云连接访问连接器。In the Power BI service, the connector can be accessed using the Cloud-to-Cloud connection from Power BI to Google BigQuery.

可以将 Power BI 与 Google BigQuery 计费项目 结合使用。You can use Power BI with the Google BigQuery Billing Project. 默认情况下,Power BI 使用从列表中为用户返回的第一个项目。By default, Power BI uses the first project from the list returned for the user. 若要自定义与 Power BI 结合使用时计费项目的行为,可执行以下步骤:To customize the behavior of the Billing Project when using it with Power BI, take the following steps:

  • 在“源”步骤的基础 M 中指定以下选项,这可以通过使用 Power BI Desktop 中的 Power Query 编辑器 进行自定义:Specifying the following option in the underlying M in the Source step, which can be customized by using Power Query Editor in Power BI Desktop:

    Source = GoogleBigQuery.Database([BillingProject="Include-Billing-Project-Id-Here"])

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