Forum Discussion
Google Analytics not showing tables
Hi
I am trying to query my Google Analytics data with Power Bi desktop. I pick the connector, add my google login details and I can see the Account and Property but I am unable to see the data tables and am therefore unable to connect to view / chart the GA data.
I have tried different accounts and get to the same point and have added colleagues to the account at the Google Analytics end but we see the account / property but no tables. If I use Google Data Studio I can see everything.
Is there something I am doing wrong? - I have the latest 64bit version of Power Bi desktop (and have reinstalled)
Thanks in advance
Hi TheGeneral ,
First, ensure that Power BI Desktop is the latest version.
Then try to clear the previous credentials and reconnect.
Steps about clearing credentials:
1.In Power BI Desktop, Go to the File menu and select Options and Settings > Data Source settings
2.Clear the credential.
The steps about connecting Google Analytics:
- In Power BI Desktop, click “Get Data” from the Home ribbon tab.
- Select “Online Services” from the categories in the left pane.
- Select Google Analytics from the list of online services.
- At the bottom of the window, click “Connect.”
- You’ll be prompted with a dialog that explains that the Google Analytics connector is a third-party service. Click “Continue” to move forward.
- You’ll be prompted to sign in to Google Analytics. When you enter your credentials, you’ll see a message that Power BI would like to have online access. To let Power BI Desktop access your GA data, you’ll want to accept.
- After you accept, Power BI Desktop will show that you’re signed in to Google Analytics.
- Select “Connect” to link your Google Analytics data with Power BI Desktop.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
adelheniHelper III
Hi, Power bi's connector for google analytics has always had its issues, the biggest being sampling.
I think it would be much easier for you to connect your google analytics data to a data warehouse and then get it to power bi.But this can be a hassle and quite technical, so I would advise you, to use a third-party connector, who already has this setup such as this one that I've been using for a while now ( https://windsor.ai/connect-google-analytics-to-power-bi-guide/).
- Burningsuit
Resident Rockstar
Hi TheGeneral
Have you clicked on the black triangles next to property? The Google Analytics data is down several levels, you need to click the black triangles to open up the heirarchy.
Hope this helps
Stuart
Hi TheGeneral ,
First, ensure that Power BI Desktop is the latest version.
Then try to clear the previous credentials and reconnect.
Steps about clearing credentials:
1.In Power BI Desktop, Go to the File menu and select Options and Settings > Data Source settings
2.Clear the credential.
The steps about connecting Google Analytics:
- In Power BI Desktop, click “Get Data” from the Home ribbon tab.
- Select “Online Services” from the categories in the left pane.
- Select Google Analytics from the list of online services.
- At the bottom of the window, click “Connect.”
- You’ll be prompted with a dialog that explains that the Google Analytics connector is a third-party service. Click “Continue” to move forward.
- You’ll be prompted to sign in to Google Analytics. When you enter your credentials, you’ll see a message that Power BI would like to have online access. To let Power BI Desktop access your GA data, you’ll want to accept.
- After you accept, Power BI Desktop will show that you’re signed in to Google Analytics.
- Select “Connect” to link your Google Analytics data with Power BI Desktop.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
same for me. I have cleared the permission, the problem still persists
