Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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:
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.
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/).
Hi
I'm having a same issue but i didn't resolved by clearing the permissions
please help
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:
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |