Connect to Google Analytics with Power BI
Connecting to Google Analytics through Power BI starts by connecting to your Google Analytics account. You will get a Power BI dashboard and a set of Power BI reports that provide insights about your site traffic and user dimensions. You can interact with the dashboard and reports, but you can't save changes. The data will be refreshed automatically once per day.
You can create customized dashboards and reports by starting from the Google Analytics connector in Power BI Desktop. Just connect with your Google Analytics account and create your custom reports, which you can publish to the Power BI service.
How to connect
Select Apps in the left navigation pane > select Get apps in the upper-right corner.
In AppSource, select the Apps tab, and search for the service you want.
Select Google Analytics > Get.
When prompted, enter your Google Analytics credentials. Select oAuth 2 as the Authentication Mechanism and click Sign In. Follow the Google authentication flow, which may include 2-factor authentication if you have it configured.
Click Accept to allow Power BI to access your Google Analytics data.
Power BI connects to a specific Google Analytics View. Select the account name, property name and view name you’d like to connect to. This information can be found in your Google Analytics account, either in the top left or on the Home tab. See details below.
Click Connect to begin the import process.
View the Google Analytics dashboard and reports
When the import is complete, the new app will appear on the Apps page.
Select Apps in the left navigation pane > select the app.
You can ask a question by typing in the Q&A box, or click a tile to open the underlying report.
- Try asking a question in the Q&A box at the top of the dashboard.
- Select a tile to open the underlying report.
- You can filter and highlight the data in the report, but you can't save your changes.
- Your dataset is scheduled to refresh daily. You can change the refresh schedule or try refreshing it on demand using Refresh Now.
To connect from Power BI, you need to have a Google Analytics account. Other Google accounts that do not have a Google Analytics account connected to it will see an authentication error.
Credentials If you have multiple Google accounts, please use an incognito or an in-private broswer window during connection to ensure the correct account is used.
If you're getting an error indicating your credentials are invalid however you were able to sign into Google, please confirm you have a Google Analytics account.
Parameters Unique names are currently required for the parameters. If you see an error indicating the value you selected is duplicated, please select another value or change the names in Google Analytics to make them unique. We're actively working to improve this.
Parameters are case-sensitive. Enter them exactly as they appear in your Google Analytics account.
Still having issues? Open a support ticket to reach the Power BI team:
- While in the Power BI app, select the question mark > Contact Support.
- From the Power BI Support site (where you're reading this article), select Contact Support on the right side of the page.