Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
egons11
Helper II
Helper II

Pipeline doesn't allow BigQuery connection

Hi, I added Bigquery connection to my Fabric tenant and everything is fine when I am using Dataflow Gen2, when trying to import the data, but when I am using Data pipeline with the same connection, when I press on that connection it just loads for a few seconds and then goes back like nothing happened.

I tried adding multiple BigQuery connections, but all the ones I added are working with a dataflow but are not working with the copy assistant in data pipeline.

 

Can you please help here?

 

 

3 REPLIES 3
v-nuoc-msft
Community Support
Community Support

Hi @egons11 

 

Can you tell me if your problem is solved? If yes, please accept it as solution.

 

Regards,

Nono Chen

No, the issue is still there

v-nuoc-msft
Community Support
Community Support

Hi @egons11 

 

The following properties must be observed to configure Google BigQuery in a pipeline:

 

Datastore type: select "External".

 

Connection: Select a Google BigQuery connection from the list of connections. If no connection exists, select New to create a new Google BigQuery connection.

 

Use Query: Choose from Table or Google SQL.

 

You can follow the documentation to try again. You can view the link below for more details:

 

Google BigQuery connector overview - Microsoft Fabric | Microsoft Learn

 

Set up your Google BigQuery connection - Microsoft Fabric | Microsoft Learn

 

Configure Google BigQuery in a copy activity - Microsoft Fabric | Microsoft Learn

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.