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 recent...
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

      • SteriCarl's avatar
        SteriCarl
        New Member
        9 years ago

        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?