topic Pipeline doesn't allow BigQuery connection in Pipelines

Pipeline doesn't allow BigQuery connection

Anonymous — Mon, 15 Jul 2024 12:40:22 GMT

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?

Re: Pipeline doesn't allow BigQuery connection

Anonymous — Tue, 16 Jul 2024 01:34:59 GMT

Hi Anonymous

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.

Re: Pipeline doesn't allow BigQuery connection

Anonymous — Fri, 19 Jul 2024 08:06:21 GMT

Hi Anonymous

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

Regards,

Nono Chen

Re: Pipeline doesn't allow BigQuery connection

Anonymous — Fri, 19 Jul 2024 08:09:37 GMT

No, the issue is still there