Skip to main content
cancel
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.

Reply
Anonymous
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

DC_BI_0-1693307120680.png

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

 

 

4 REPLIES 4
JahidBenhagoug
Frequent Visitor

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

SezT
New Member

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

Anonymous
Not applicable

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

Trying pass these

 

DC_BI_1-1693317619379.png

 

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
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

Announcements
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

PBI_APRIL_CAROUSEL1

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