Publishing A Google Analytics Information Supply Or A Workbook Linked To A Google Analytics Information Supply into Tableau Server
We will create informative reviews on our web site analytics utilizing Tableau. Tableau has the power to hook up with a Google Analytics knowledge 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 will publish a Google Analytics knowledge supply right into a Tableau sever? How we will publish created Tableau worksheets which can be linked to a Google Analytics knowledge supply into the Tableau server? Why the above error message pops up and the way we will resolve the issue? These and a few extra questions are going to be answered within the following put up. However, initially, how we will use Tableau to create reviews based mostly on Google Analytics knowledge sources?
Open Tableau desktop and
1. Click on on “Hook up with knowledge”
2. From “Hook up with Information” pane click on on “Google Analytics”
3. Enter the credentials and click on “Register”
4. Settle for the permissions that Tableau Desktop wants to hook up 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 register to a different Google account simply click on on “Change Signal In…” button
f. Click on OK
6. Now we will create a report for website visits per date. Identify the worksheet as Google Analytics.
1. Proper click on on “Google Analytics” knowledge 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 simply need 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 could embed credentials. In the event you proceed to publish with out embedding credentials, this datasource might be faraway from any current schedules. Would you wish to embed credentials now?” Right here you when you 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 finished.
As mentioned in Introduction part, Tableau can’t cross Google credentials unattended; a minimum of it can’t try this now. So, the printed knowledge supply must be refreshed manually. To refresh the Google Analytics knowledge supply:
1. Open Tableau desktop and choose “Tableau Server” from the left pane
2. Enter your Tableau credentials to hook up with Tableau server
3. Choose the positioning
4. Click on on “Google Analytics” knowledge supply
5. Proper click on on the Google Analytics knowledge source-> Tableau Information Server-> Refresh from Supply
6. Enter the credentials and click on “Register”
7. Settle for the permissions that Tableau Desktop wants to hook up with your Google account
8. The information supply is efficiently refreshed.
Thus far we didn’t resolve the issue! The issue was that once we needed to publish the Google Analytics knowledge 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 received’t be refreshed mechanically based mostly on a predefined schedule in Tableau server. However, why Tableau server can’t cross the Google credentials? We have to verify 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 be capable 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 knowledge 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 knowledge supply is efficiently printed and it’ll refresh mechanically from Tableau Server based mostly on chosen schedule.
We will verify the schedule activity from Tableau Server to see if the printed knowledge supply is refreshing as anticipated. All finished.