Forum Discussion

SteriCarl's avatar
SteriCarl
New Member
9 years ago

Google Analytics Invalid Token

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:

 

Error message

 

All the other connections in my report work fine.

 

Any ideas on how to fix this?

 

Thanks,

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      SteriCarl
      New Member
      9 years ago

      Hi Anonymous,

       

      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's avatar
        SteriCarl
        New Member
        9 years ago

        Hi Anonymous,

         

        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