Big Query connection on Dataflow (with mixed table sources)

[Anonymous]

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

[JahidBenhagoug]

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

[SezT]

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

[Anonymous]

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

[Anonymous]

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