Pipeline doesn't allow BigQuery connection

[egons11]

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?

[v-nuoc-msft]

Hi @egons11 

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

Regards,

Nono Chen

[egons11]

No, the issue is still there

[v-nuoc-msft]

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.