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

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register 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!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.