Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

Dataflow
Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

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

  • SezT's avatar
    SezT
    New Member
    2 years ago

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

  • JahidBenhagoug's avatar
    JahidBenhagoug
    Frequent Visitor
    2 years ago

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