Hello,
I'm trying to read some data from one of my clients' google analytics account. The problem I have is that I can`t see any database's content.
As you see in the image, the database "xxx" is deployed but showing nothing.
Am I doing something wrong or just should check a specifict something ? Had anyone had this trouble and solved it?
HELP PLEASE
Solved! Go to Solution.
Hi, @Maricel
In the navigator box, you can select which data you would like to be loaded into Power BI. The options are set up the same way that the Google Analytics account hierarchy is set up.
The top-level is the Account, the second level is the Property, and the bottom level is the View. Select which account, property, and view that contains the data you are looking for.
In order to load in the data, you must ensure that you have the proper permissions in Google Analytics.
Please refer to below tutorials.
How to Connect Google Analytics to Microsoft Power BI
Understanding Google Analytics User Permissions at Account, Property and View Level
Best Regards,
Community Support Team _ Eason
Hi @Maricel were you able to find a solution? I tried to connect my GA4 data to PBI last week and had the same issue. I had to connect my data through Windsor connector momentarily and works fine so far but I can only see my data up to the last 28 days for free. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:
After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi @Maricel
You're having a problem because the Google Analytics connector in PBI only works with UA, not GA4. As it stands, there is no native GA4 connector so you need to find a custom solution.
Everyone is having the same problem and there are more or less 3 solutions at present.
I went with option 3, got it all working first try - but pick the option that you're most comfortable with. Best of luck!
Hi, @Maricel
In the navigator box, you can select which data you would like to be loaded into Power BI. The options are set up the same way that the Google Analytics account hierarchy is set up.
The top-level is the Account, the second level is the Property, and the bottom level is the View. Select which account, property, and view that contains the data you are looking for.
In order to load in the data, you must ensure that you have the proper permissions in Google Analytics.
Please refer to below tutorials.
How to Connect Google Analytics to Microsoft Power BI
Understanding Google Analytics User Permissions at Account, Property and View Level
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
118 | |
63 | |
61 | |
41 | |
40 |
User | Count |
---|---|
118 | |
67 | |
65 | |
64 | |
50 |