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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

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! Early Bird pricing ends December 9th.