Changing Data Source From AlloyDb to Big Query?

[amilpbi]

We have an old Report that uses GCP alloyDb database To Establish ODBC with PostgrSQL connector with a SQL query to fetch Data.
Can we Change the Data Source to Big Query that uses a Different SQL Query but results the same Data Table.
As the ODBC Method refreshes as long as the VM instance is running, given that its configured to Turn itself off every evening, I have to restart it every day. 
I belive this problem can be erased with Big Query but unsure if we can just change the source and still maintain Table relationship and All DAX still remain operating.

[Ritaf1983 · Accepted solution]

Hi @amilpbi 

If your tables in BigQuery have exactly the same structure as those from AlloyDB (same table names, column names, and data types), then in most cases, you should be able to swap the data source without breaking relationships or DAX measures.

To minimize issues, I recommend the following:

1. Ensure schema consistency – Column names, data types, and table names must match exactly.

2. Use “Transform Data” to replace the source in Power Query rather than re-importing everything – this way, the data model structure is preserved.

3. Refresh carefully and test visuals and measures to confirm everything works as expected.

Also, switching from ODBC to BigQuery may significantly improve refresh reliability and performance, especially if the VM powering AlloyDB shuts down nightly.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly