Connection with Google analytics

[yugofukuda]

Hi,

I´m trying to connect google analytics with Power bi but it doesn´t work well as below and there are no tables. 

how can I solve this problem? My account works on the page of google analytics and there are datas (not so big) but just the connection dosen´t work. I would appreciate your help, thanks.

[ReportMaster]

Hi @yugofukuda, 

I know this reply is very late lol but were you able to find a solution? I used the GA native connector but had some issues with my data sometimes. Maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA connector in the data sources list:

After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA 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.

[V-lianl-msft]

Hi @yugofukuda ,

On the left it provides some display options where i can collapse some folder/DBs and begin to look into the pieces of data that i want.

If you don't have these i would suggest it is insufficent permissions or it is incorrect login details.

In addition, when you need to google sheet, you need to change URL as below

change

https://docs.google.com/spreadsheets/d/google-sheet-guid/edit?usp=sharing

to 

https://docs.google.com/spreadsheets/d/google-sheet-guid/export?format=xlsx&id=google-sheet-guid

You could refer to How to connect google sheet with power bi?  for details.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yugofukuda]

Thank you for your reply!!

Unfotunately, It still doesn´t work well even if Google analytics has an access to Power Bi.  I can´t see any folders on Power BI. How can I solve this problem?