Passing data from the GA4 API to Power BI/ Passagem dos dados da API GA4 para o Power BI

[Elisandra_Calda]

 

Good afternoon, can someone please help me to connect Google Analytics API 4 to Power BI?
In fact, I know that it doesn't connect to the latest version and it makes it difficult for me to use external connectors like widsor.ai, so I had to activate the GA4 API and I can already get the data via Python, but I want to pass this data to the Power BI how can I do this? I can't get the GA4 API URL.

Boa tarde, alguém pode por favor ajudar-me a conectar a API do Google Analytics 4 para o Power BI?

Na realidade sei que ele não conecta com a versão mais recente e fica-me complicado usar conectores externos como o widsor.ai, portanto tive mesmo que activar a API do GA4 e já consigo pegar os dados via Python, porém quero passar esses dados para o Power BI como posso fazer isso? Não consigo pegar a URL da API do GA4.

[sambo345]

Hi if you're still looking for a solution this might help: https://cooriedug.com/custom-ga4-power-bi-connector-setup/

[Adel]

Hello, you can you use a connector like windsor.ai to connect GA4 to Power bi, it's very easy and fast.
here is the list of fields you can query.
https://windsor.ai/connector/googleanalytics4/

[v-yueyunzh-msft · Accepted solution]

Hi , @Elisandra_Calda 

According to my search and research, Power BI destkop comes with a built-in Google Analytics connector, and there is also a specific description of the specific requirements for the connection, you can refer to this link:

Power Query Google Analytics connector - Power Query | Microsoft Learn

In the meantime, you can also refer to the following documents for further reference and configure the connection to the Google Analytics API according to your situation:

Power BI + Google Analytics = Power Analytics | Microsoft Power BI Blog | Microsoft Power BI

Power BI Google Analytics 4 Connector - Microsoft Power BI Community

Best Regards,

Aniya Zhang

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

[raushiks]

I am successfully able to connect with the GA4 via PBI, but getting aggregate value is still a challenge as on summing up it is showing different value in PBI while GA4 shows different values (this might be uique) but there is no such columns available to calculate it to the exact.