Connecting to Google Analytics Demo Account Gives an Error 403

[Chiransj]

Hi All,

I am trying to connect Google Analytics Demo Account to PowerBi Desktop. I tried the following steps.

1. Selected Get Data
2. Selected Google Analytics
3. Clicked Connect
4. I can see 1 connection i.e
   
5. I had exapand the tree until to display 1 Master View [10] and from that I have tried to select one of the items as shown in the below screenshot
   
6. Then I expanded one of the categories and clicked on the check box and I could see the message "preview is evaluating" and then suddenly the below message is showing.
   

I tried several times to connect this and could not make it work. What is the issue with this?

Could someone please let me know any working Google Analytics resource rather than this demo account?

Thanks and regards,
Chiranthaka

[v-yuezhe-msft · Accepted solution]

@Chiransj,

I can successfully load data from Google Analytics into Power BI Desktop. Based on this article, to solve the 403 error,  you would need to get sufficient permissions to perform the operation on the specified entity on Google Analytics side.

There is a simliar thread about how to grant service account permissions for your reference.
https://stackoverflow.com/questions/20959942/google-analytics-api-user-does-not-have-sufficient-perm...

Regards,

Lydia