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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Not applicable

Big Query connection on Dataflow (with mixed table sources)

Getting an error setting up new dataflows to bigquery using either existing gateway connection or new connection.

Strange as existings connections work fine using same connection just cant setup anything new.


When selecting existing connection getting this

An exception occurred: 'ProjectId' are not valid BigQuery options. Valid options are: 'BillingProject, UseStorageApi, ConnectionTimeout, CommandTimeout' (Session ID: d30210b0-74f2-4d5f-8091-e1e1e77344e6, Region: europe)


The service is trying to pass a param not recognised by Bigquery


Get same issue if i dont sue gateway then try and use mixed tbale sources



Frequent Visitor

I also have the same issue since this update, can someone from Microsoft help ?

New Member

Having the same issue. The only working solution I have found is the same as yours. I hope they fix this soon!

Not applicable

So with further trial and error it seems the PBIs ervcie is passing wrong params to bigquery

Trying pass these




But should be this, editng power query to correct params works

GoogleBigQuery.Database([UseStorageApi = null, ConnectionTimeout = null, CommandTimeout = null, BillingProject = "XXXXXXX"])
I dont want to accept this as solution MS needs to fix this, was fine before fabric update
Not applicable

Any help with this? Its a major blocker as our Datwarehouse is in Bigquery and the service is getting the above error?!

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors