We will create informative reviews on our web site analytics utilizing Tableau. Tableau has the power to connect with a Google Analytics information supply. The issue is that if Tableau can’t cross the credentials to Google mechanically, the next error message pops up.

“An error occurred when publishing the info supply. GetOAuthUsername caught exception processing specs. Response code: 500”

So, how we are able to publish a Google Analytics information supply right into a Tableau sever? How we are able to publish created Tableau worksheets which can be linked to a Google Analytics information supply into the Tableau server? Why the above error message pops up and the way we are able to resolve the issue? These and a few extra questions are going to be answered within the following put up. However, to begin with, how we are able to use Tableau to create reviews primarily based on Google Analytics information sources?

Open Tableau desktop and

1.       Click on on “Hook up with information”

2.       From “Hook up with Knowledge” pane click on on “Google Analytics”

3.       Enter the credentials and click on “Sign up”

4.       Settle for the permissions that Tableau Desktop wants to connect with your Google account

5.       Comply with the steps under:

a.       Select an Account, Property and Profile

b.      Choose date vary

c.       Choose dimensions and measures (as much as 7 dimensions and 10 measures)

d.      Give the connection a reputation to be used in Tableau

e.      If you wish to check in to a different Google account simply click on on “Change Signal In…” button

f.        Click on OK

6.       Now we are able to create a report for website visits per date. Identify the worksheet as Google Analytics.

1.       Proper click on on “Google Analytics” information supply from the info pane and click on “Publish to server”

2.       Enter your Tableau credentials and click on OK

3.       Choose the positioning that you just wish to publish the info supply

4.       Add the customers that ought to see the worksheet and set their permissions by clicking on “Add…” button, then click on “Publish”

5.       Now, Tableau asks the next query “For this datasource to be scheduled for refresh on the Server, you will need to embed credentials. For those who proceed to publish with out embedding credentials, this datasource might be faraway from any present schedules. Would you wish to embed credentials now?” Right here you if you happen to click on “Sure” the error message will pop up, so, for now simply click on “NO”.

6.       Now the Google Analytics datasource is printed into Tableau server.

1.       In Tableau desktop, open “Server” menu and choose “Publish Workbook”

2.       Click on “Publish”

3.       Tableau will ask the identical query quantity 5 in earlier part. Click on “NO”.

4.       All executed.

As mentioned in Introduction part, Tableau can’t cross Google credentials unattended; at the least it can’t try this now. So, the printed information supply must be refreshed manually. To refresh the Google Analytics information supply:

1.       Open Tableau desktop and choose “Tableau Server” from the left pane

2.       Enter your Tableau credentials to connect with Tableau server

3.       Choose the positioning

4.       Click on on “Google Analytics” information supply

5.       Proper click on on the Google Analytics information source-> Tableau Knowledge Server-> Refresh from Supply

6.       Enter the credentials and click on “Sign up”

7.       Settle for the permissions that Tableau Desktop wants to connect with your Google account

8.       The info supply is efficiently refreshed.

Thus far we didn’t resolve the issue! The issue was that once we wished to publish the Google Analytics information supply into Tableau server, if Tableau server couldn’t cross the credentials to Google, an error message pops up. If we don’t choose “Embedded password” in “Authentication” half once we are publishing the Google Analytics into Tableau server, the info supply gained’t be refreshed mechanically primarily based on a predefined schedule in Tableau server. However, why Tableau server can’t cross the Google credentials? We have to test our firewall settings to see if it blocks ports 80 and 443. Google Analytics makes use of ports 80 and/or 443. After correcting the firewall settings Tableau server ought to have the ability to cross Google Analytics credentials. So, we have to republish the Google Analytics into Tableau.  The steps for publishing are the identical as we did earlier than in quantity 5 of “Publishing Google Analytics information supply into Tableau” part. The one distinction is that we have to choose “Embedded password” in Authentication part. We will choose a predefined schedule in “Refresh Extract – Full” part and the clicking “Publish”.

Now the Google Analytics information supply is efficiently printed and it’ll refresh mechanically from Tableau Server primarily based on chosen schedule.

We will test the schedule activity from Tableau Server to see if the printed information supply is refreshing as anticipated. All executed.