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 Liu!
I guess I miss some details :).
1 - Company works with Microsoft suit
2 - BigQuery is used because they implemented GA4 and need raw data to create PBI dashboards
3 - They already had a partner who created some PBI dashboards and I attach a measure architecture image
4 - What I need to know is to learn this process (or a better/simpler one), because I no idea how they created that dashboards but I co-in charge of doing some more 😞
With this information, I hope to be more specific and clarified some points. I am sorry, but this is a new (but hot) topic for me.
Thank you!