Forum Discussion
Creating PBI dashboards from GA4/BigQuery Data - What is the process
Hi JoaoMatos ,
In general, if you are using a database that has a specific connector in Power bi, it is recommended to use the specific connector because it was created specifically for the database, for example, Power BI Desktop supports the Google BigQuery connector
Google BigQuery connector - Power Query | Microsoft Learn
If you want to use another way to connect to get data, you can consider using ODBC plugin as a bridge to connect, please refer to this document to use PBI to connect to ODBC connector.
Power Query ODBC connector - Power Query | Microsoft Learn
How to Connect to an ODBC Data Source From Power B... - Microsoft Fabric Community
This is the related document, you can view this content:
Solved: How to query Google Analytics 4 data via BigQuery ... - Microsoft Fabric Community
https://zebrabi.com/guide/how-to-integrate-google-bigquery-into-power-bi/
Create a Power BI dashboard from a report - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JoaoMatos ,
In general, if you are using a database that has a specific connector in Power bi, it is recommended to use the specific connector because it was created specifically for the database, for example, Power BI Desktop supports the Google BigQuery connector
Google BigQuery connector - Power Query | Microsoft Learn
If you want to use another way to connect to get data, you can consider using ODBC plugin as a bridge to connect, please refer to this document to use PBI to connect to ODBC connector.
Power Query ODBC connector - Power Query | Microsoft Learn
How to Connect to an ODBC Data Source From Power B... - Microsoft Fabric Community
This is the related document, you can view this content:
Solved: How to query Google Analytics 4 data via BigQuery ... - Microsoft Fabric Community
https://zebrabi.com/guide/how-to-integrate-google-bigquery-into-power-bi/
Create a Power BI dashboard from a report - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Liu!
We did it by connecting BQ in Azure Fabric and creating a SQL query to unnested all the fields of GA4 in BQ. Then is just working in PBI as usually.