Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Extracting Data from Google Analytics

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 ?  
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.