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