The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
The client im working with is going to move its data from Teradata to Google Big Query. They have a lot of Power BI reports with Teradata as the source. For reporting they have built lots of views in Teradata that are used in Power Bi. The expectation is that all the tables and views will be migrated to Google Big Query with the Server, DB , table and view names remaining the same as they were in Teradata.
I would like to know the steps for migration for the below scenario:
A workspace can have multiple datasets and Multiple reports built on each dataset.
Each dataset has a single source for e.g. Teradata db with multiple tables / views.
thanks.
Solved! Go to Solution.
Migrating from Teradata to Google BigQuery is not a power bi issue, but here I found some documentation that may be of some help to you:
You need to have a Google Cloud account with billing enabled before you start the migration.
Enable the BigQuery, BigQuery Data Transfer Service, Cloud Storage, and Pub/Sub APIs.
Create a service account with the necessary permissions.
Migrate schema and data from Teradata | BigQuery | Google Cloud
Migrating Teradata to BigQuery tutorial | Google Cloud
After completing the migration, you will need to change the power bi report to point to the new data source in BigQuery.
6 Ways to Change Data Source in Power BI - Power Tech Tips
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Migrating from Teradata to Google BigQuery is not a power bi issue, but here I found some documentation that may be of some help to you:
You need to have a Google Cloud account with billing enabled before you start the migration.
Enable the BigQuery, BigQuery Data Transfer Service, Cloud Storage, and Pub/Sub APIs.
Create a service account with the necessary permissions.
Migrate schema and data from Teradata | BigQuery | Google Cloud
Migrating Teradata to BigQuery tutorial | Google Cloud
After completing the migration, you will need to change the power bi report to point to the new data source in BigQuery.
6 Ways to Change Data Source in Power BI - Power Tech Tips
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
24 | |
23 | |
14 |