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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept Fabric Carousel

Fabric Monthly Update - September 2024

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

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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