Extracting Data from Google Analytics

[Anonymous]

Hello , i want to extract dala from Google Aanlytics to create dashboard ,just want to to know what is the best way to do it ?

[ReportBuilder07]

Hi @Anonymous Do you want to pull GA4 data? If that's the case, you have the 2.0 beta connector but that one has some issues. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) 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 GA4 connector in the data sources list:

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your G4 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. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

would you like to connect the Google Analytics from power bi desktop and then publish to the service?

You can connect to Google Analytics data using the Google Analytics connector. To connect, follow these steps:

1. In Power BI Desktop, select Get Data from the Home ribbon tab.
2. In the Get Data window, select Online Services from the categories in the left pane.
3. Select Google Analytics from the selections in the right pane.
4. At the bottom of the window, select Connect.

You're prompted with a dialog that explains that the connector is a Third-Party Service, and warns about how features and availability may change over time, and other clarifications.

When you select Continue, you're prompted to sign in to Google Analytics.

When you enter your credentials, you're prompted that Power BI would like to have offline access. This is how you use Power BI Desktop to access your Google Analytics data.

Once you accept, Power BI Desktop shows that you're currently signed in.

More details: Third-party service: Google Analytics connector - Power BI | Microsoft Learn

Or you might be looking for a third-party connector, you would just have to connect your Google Analytics account to the platform and they get your data into power bi and it will be refreshed automatically without asking for a user id nor password.

https://www.youtube.com/watch?v=v3WA6-jk5EM&ab_channel=Windsor.aiPerformanceMarketing

this video has a guide on how to do it.

windsor.ai

Best Regards
Community Support Team _ Polly

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