Edit

Share via


Set up your Google BigQuery connection

This article outlines the steps to create a Google BigQuery connection.

Supported authentication types

The Google BigQuery connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Service Account Login
Organizational account n/a

Set up your connection in Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to Google BigQuery using Power Query connectors. Follow these steps to create your connection:

  1. Get data from Data Factory in Microsoft Fabric.
  2. Set up Google BigQuery prerequisites.
  3. Check Google BigQuery limitations and considerations to make sure your scenario is supported.
  4. Connect to Google BigQuery data (from Power Query Online).