What are the steps to connect Power Automate to a BigQuery dataset?

Does any know the steps to connect Power Automate to a BigQuery dataset?

Steps to Connect Power Automate to BigQuery Set Up Firebase Project: Ensure you have a Google account or a Google service account to sign in to Google BigQuery.

Install the BigQuery Connector: Use the CData ODBC Driver for BigQuery to integrate BigQuery data into Power Automate. Install the driver and configure the ODBC data source name (DSN)2.

Create a Connection in Power Automate: Log into Power Automate and create a new connection. Select SQL Server as the connection type and configure the connection details, such as the SQL server name, database name, username, and password1.

Integrate BigQuery Data: Use the connection to integrate BigQuery data into your Power Automate workflows. You can now access live BigQuery data and use it in your automated tasks2.

Detailed Steps Install CData ODBC Driver for BigQuery: Download and install the CData ODBC Driver for BigQuery. Configure the ODBC data source name (DSN) with the necessary connection properties2.

Create a New Connection in Power Automate: Go to Power Automate and click on "Data" -> "Connections" -> "New connection". Select SQL Server as the connection type3.

Configure Connection Details: In the connection wizard, set the SQL server name to tds.cdata.com,14333, the SQL database name to the name of your BigQuery connection (e.g., GoogleBigQuery1), and the username and password to your Connect Cloud user credentials.

Connect to BigQuery: Click "Create" to establish the connection. You should now be able to access BigQuery data from Power Automate2.