Google Analytics connection

[JhonataBossa]

Hey, guys,

I need urgent help, I am trying to connect a lot of Google Analytics data in Power BI Dsktop, however, when I connect with my Google credentials in Power BI, the base appears, but does not show me the tables for working with ETL.

[QueryWhiz]

Hi @JhonataBossa were you able to find a solution? I used the GA native connector but had some issues with my connection sometimes. As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:

After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.

[AshmaP]

@JhonataBossa 
Is this problem of your resolved?
I am facing the similar problem now. Thanks!

[v-robertq-msft · Accepted solution]

Hi, @JhonataBossa 

What’s the credential you used to log in and connect the Google Analytics data to Power BI Desktop?

According to the awareness in the Power BI support page, the Power BI customers authoring reports with Google connectors will be impacted when Google deprecates embedded/native browser auth for OAuth which is scheduled to take place for Power BI by the end of June 2021.

For more information, you can turn to this site:

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[NimaiAhluwalia]

Hello @JhonataBossa 

if the above screen appears means there may be a connection or an access issue from the source also do try to refresh in the above preview also try to check out and see if you can populate data of google analytics in an app from AppStore.

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

[JhonataBossa]

Good morning Nimai,

I have already followed these steps, what I came closest to was Big Query (Cloud Goggle). But the data is collected as events, however, they bring that data to Power BI as each event being a table (1 event = 1 day). So for each day he brings me a table, which ends up generating a lot of work, to fix each base every day it would have to be done manually.

[JhonataBossa]

@NimaiAhluwalia Here is an example