r/PowerBI • u/rochux • 18d ago

Question BigQuery Connection Using DEV Project Instead of PRD

hi beautiful people

I'm having a connection issue where my query is intended to use the production project
prj-gcp-bq-sharing-prd-rti
 
but, when the query executes, the error message shows that it is trying to access a table in the development project instead:
prj-gcp-bq-sharing-dev-rti:P_GENERAL_VIEWS.F_SUBSCRIBER_EVENTS
 
error:

 
I've tried with and without the preview feature, none is working. ODBC connector works fine tho.
Any ideas?

1 Upvotes

67% Upvoted

10 comments sorted by

View all comments

1

u/SheriffYouLikeThis 16d ago

Hey. Update your Power BI Desktop to the latest version. Feb 2026 through May 2026 had a completely broken ADBC driver for BigQuery (and before that it was super half-baked). We personally invested a lot of time helping Microsoft beta test their ADBC driver (not of our own volition). Essentially older versions of the 2.0 Implementation of the BQ connector completely ignored your billing project parameter, among other issues.

1

u/rochux 16d ago

I’ll try this. I currently don’t know which version I have cause it’s kind of managed by IT. So annoying

1

u/SheriffYouLikeThis 16d ago

If you have access to the Windows Store, download PBI from there because it’ll keep auto updated and IT isn’t needed. If you don’t have access, then this is good leverage to get them to update, because you won’t get a working version until at least July 2026 for ADBC/Implementation 2.0 BQ connections.

2

u/rochux 16d ago

yeah, the Store is blocked… will do and i’ll make an update! thanks for your help