Forum Discussion

yugofukuda's avatar
yugofukuda
Helper IV
4 years ago

Connection with Google analytics

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 analytic...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

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's avatar
    yugofukuda
    Helper IV
    4 years ago

    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?