Google Analytics Invalid Token

[SteriCarl]

Hi All,

I built my reporting pack in the desktop version of Power BI a few months ago and was pulling in data from various sources, including Google Analytics, which all worked fine.

I recently received a new work laptop and installed Power BI on it then loaded in my previously built reporting pack, however when I now try to connect to Google Analytics I get the following error:

All the other connections in my report work fine.

Any ideas on how to fix this?

Thanks,

[v-yuezhe-msft]

@SteriCarl,

In the laptop, are you able to directly sign in Google Analytics using your account in browser?

In addition, I would recommend you open a new blank Power BI Desktop file, go to Options and Settings -> Data Source Settings - Global permissions in Power BI Desktop, clear permission of any old connections about Google Analytics, then re-connect to Google Analytics and check if it is successful.


Regards,
Lydia

[SteriCarl]

Hi @v-yuezhe-msft,

Thanks for getting back to me.

I am able to sign into my google account without issue.

I also already tried clearing existing permissions and then re-connecting. Unfortunately this didn't work either.

Regards,

Carl

[SteriCarl]

Hi @v-yuezhe-msft,

I have found the solution to the problem.

1. In the registered google account under 'Sign-in & security' select 'Connected apps & sites'.

2. Select 'MANAGE APPS'.

3. Find Power BI in the list of connect apps, select it and then click 'REMOVE'.

4. Uninstall Power BI Desktop and Reinstall it.

5. Follow the usual connection instructions to connect to Google Analytics.

I'm guessing when moving from one machine to another there is a problem with syncing the access tokens generated which causes this issue.

Hope this helps somebody else.

Carl

[SteriCarl]

OK, so the above solution worked yesterday.

I've just opened my report and attempted to refresh and I am getting the original error again!

Why is this happening?

[vincentL1]

Hi,

I've resolved the problem.

You have an invalid token when you use your google account on many support.

Last eveneing, i deleted my account on my personnal computer. Today, i can use the GA connector on my work computer.

[shailaja_reddy]

Hello,

Has anyone found solution to this issue. I've successfully connected to Google Analytics from Power BI Desktop earlier. When I tried to refresh recently it throws 'Invalid Token' error. Tried all the solutions mentioned in this post(including enabling TSL 1.2). Please help!!

P.S. Havent used my account in other systems.

[vincentL1]

Hi,

After a chat with the IT, the problem was the proxy used by my company.

[vincentL1]

Hi

I have the same issue.

Somebody has found a solution ?

Thanks,