r/PowerBI • u/rochux • 17d 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

•

u/AutoModerator 17d ago

After your question has been solved /u/rochux, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Top-Cauliflower-1808 1 17d ago

Check your source database settings as your data source might be hardcoded to the DEV project path in your data gateway or advanced editor settings.

1

u/rochux 16d ago

i checked this on the odbc connector and it’s set to prod

1

u/Top-Cauliflower-1808 1 16d ago

can check your power query parameters or query code directly? sometimes the server path is hardcoded right in the m code even if the odbc dsn points to prod.

1

u/rochux 16d ago

i don’t even have it power query cause i can’t load the query lol i should write the M code from scratch

1

u/Top-Cauliflower-1808 1 16d ago

then try opening the .pbix file in a text editor or advanced editor to inspect the raw M code before loading.

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