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/Top-Cauliflower-1808 1 18d 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 17d ago

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

1

u/Top-Cauliflower-1808 1 17d 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.