Forum Discussion

willayd's avatar
willayd
Icon for Advocate I rankAdvocate I
6 years ago

Connecting to Google Analytics from Power BI Service via Service Account

Is there a best practice for connecting to Google Analytics via the Power BI Service on an automated schedule? My use case is to refresh GA data once per day, but ideally without having to code any p...
Need Help
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi willayd 

 

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.

 

Please note that after publish it to the service and schedule refresh, it doesn't require any gateway.