Forum Discussion

TheGeneral's avatar
TheGeneral
New Member
4 years ago
Solved

Google Analytics not showing tables

Hi   I am trying to query my Google Analytics data with Power Bi desktop. I pick the connector, add my google login details and I can see the Account and Property but I am unable to see the data ta...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi TheGeneral ,

     

    First, ensure that Power BI Desktop is the latest version.

     

    Then try to clear the previous credentials and reconnect.

    Steps about clearing credentials:

    1.In Power BI Desktop, Go to the File menu and select Options and Settings > Data Source settings

    2.Clear the credential.

     

    The steps about connecting Google Analytics:

    1. In Power BI Desktop, click “Get Data” from the Home ribbon tab.
    2. Select “Online Services” from the categories in the left pane.
    3. Select Google Analytics from the list of online services.
    4. At the bottom of the window, click “Connect.”
    5. You’ll be prompted with a dialog that explains that the Google Analytics connector is a third-party service. Click “Continue” to move forward.
    6. You’ll be prompted to sign in to Google Analytics. When you enter your credentials, you’ll see a message that Power BI would like to have online access. To let Power BI Desktop access your GA data, you’ll want to accept.
    7. After you accept, Power BI Desktop will show that you’re signed in to Google Analytics.
    8. Select “Connect” to link your Google Analytics data with Power BI Desktop.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi TheGeneral ,

 

First, ensure that Power BI Desktop is the latest version.

 

Then try to clear the previous credentials and reconnect.

Steps about clearing credentials:

1.In Power BI Desktop, Go to the File menu and select Options and Settings > Data Source settings

2.Clear the credential.

 

The steps about connecting Google Analytics:

  1. In Power BI Desktop, click “Get Data” from the Home ribbon tab.
  2. Select “Online Services” from the categories in the left pane.
  3. Select Google Analytics from the list of online services.
  4. At the bottom of the window, click “Connect.”
  5. You’ll be prompted with a dialog that explains that the Google Analytics connector is a third-party service. Click “Continue” to move forward.
  6. You’ll be prompted to sign in to Google Analytics. When you enter your credentials, you’ll see a message that Power BI would like to have online access. To let Power BI Desktop access your GA data, you’ll want to accept.
  7. After you accept, Power BI Desktop will show that you’re signed in to Google Analytics.
  8. Select “Connect” to link your Google Analytics data with Power BI Desktop.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.