Forum Discussion
Changing Data Source From AlloyDb to Big Query?
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:
-
Ensure schema consistency – Column names, data types, and table names must match exactly.
-
Use “Transform Data” to replace the source in Power Query rather than re-importing everything – this way, the data model structure is preserved.
-
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
-
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:
-
Ensure schema consistency – Column names, data types, and table names must match exactly.
-
Use “Transform Data” to replace the source in Power Query rather than re-importing everything – this way, the data model structure is preserved.
-
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