So today I was pulling down the connection from the server and was able to edit the connection and add new measures easily enough, but after about 2 hours I went back again and once again this error popped up and now I'm back to where I started.
Is there no one else that is having this issue?
1 of 1 people found this helpful
I have got the same problem.
One (big) workbook with multiple GA datasources - first uploaded to Tableau Server, but after downloading these datasources I also got the 'missing required context variable: account-id', and also - maybe related - and some other extract issues, which all come down to a 'extract not found' error.
Thanks Johan for making me not think I'm crazy.
This issue is now happening across ALL of our GA datasources. It is incredibly frustrating. Now every time I need to pull down the connection from the server to add a new column or change something in the connection, I have to completely rebuild it from scratch - which takes so much time.
I don't understand what the issue even is here, the error makes it sound like I don't have access to google analytics, yet the extract refreshes just fine with no issues.
Again, does anyone have any idea what might be happening?
Also happening to me as well. No idea what's causing the issue, but hoping to give it more attention so it's addressed soon.
It's happening to me as well. It started earlier this week.
If you look at the affected extract's properties, the Account row is empty. If you compare it to a still functioning one, there should be information present.
I tested out a workbook with extracts hosted directly on my computer rather than online. They work perfectly until I uploaded the workbook to Tableau. Afterwards, the Account-ID error starts up.
Hey everyone -- I'm in Support at Tableau and we would like to investigate this further. Can you submit support tickets here: Submit a case to our support team | Tableau Software ? It will help us out if you can include in the ticket:
+Screenshot of the error
+Let us know if there are multiple properties set up under the same account as this may be part of the issue
+Exact steps to reproduce the issue
+Full version (Help>About Tableau -- the full build is on the top right above the Tableau logo)
a. Make sure all instances of Tableau Desktop are closed.
b. Navigate to My Documents > My Tableau Repository > Logs
c. Rename the logs folder to Logs_Backup
d. Recreate the issue, then close Tableau Desktop
e. Send desktop logs. Please see http://www.tableausoftware.com/support/knowledge-base/sending-tableau-desktop-log-files for instructions on bundling and sending the files.
Also let us know if you have a workaround and what that is. We can document it and share it with others while we do some root cause analysis on this.
Was it resolved at all ? Im having the same problem with multiple ga data sources in the spreadsheet.
Thanks, sent a ticket under number 02518804.
Any news on this?
I was told to contact Tableau Support directly. I've been working with them to figure out the issue. They need to see networking traffic logs to help diagnose the problem on both your computer and your tableau server, which unfortunately with the type of data my company deals with we can't provide that level of access.
I did however find that Tableau 9.3.4 does not have this problem. At least for me that is a potential workaround.
You should submit a ticket if this is something that is happening to you - the tech I worked with was very understanding and helpful.
thank you for the prompt response! We recently updated to Tableau 10, which might have contributed to the problem.
I'll get in touch with Tableau Support then.
The same thing has been happening to me and I don’t know the cause.
However, I have found a workaround to fix the issue. The Tableau workbook file (.twbx) is essentially an XML file that that stores all the information for the Tableau engine to interpret. If you open the file using a text/source code editor like Notepad++ then you will see the Tableau XML structure. If you collapse all the tags you will see something like this:
Under the tag “<datasources>” will see all the data sources in your workbook (as well as parameters, sets, etc.). Find the data source that is giving you the context variable error. Directly under the <datasource> tag will be the <connection> tag. The problem, at least for me, was that for some reason Tableau no longer had key pieces of information to connect to GA. The fields highlighted in blue (see code below) are the context variables that Tableau needs to connect to GA. I bet in your file those fields are missing or empty
<connection REDIRECT_URI='urn:ietf:wg:oauth:2.0:oob' SCOPE='https://www.googleapis.com/auth/analytics.readonly https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile' account-id='XXXXXXX' account-name='XXXXXXXX' can-partition='yes' class='google-analytics' currency='' date-type='11' dimensions='ga:date,ga:keyword,ga:networkLocation,ga:pagePath,ga:pageTitle,ga:sourceMedium,ga:userType' end-date='2016-06-05' goal-name-ids='' incremental-refresh-enabled='false' metrics='ga:organicSearches' profile-id='XXXXXXXX' profile-name='XXXXXXXXXXXXXXXXXX' property-id='XXXXXXXXXXXX' property-name='XXXXXXXXXXXXXXXX' request-unsampling='yes' response-sampled='yes' sample-size='965492' sample-space='11545465' sampled-data='no' segment-id='iP0oUy7zQnyqFF-disK9pw' segment-name='All Visits (-1)' server-oauth='' start-date='2015-01-01' total-results='4483' username=' '>
If they are missing or empty you can either type in the missing information or go to a data source that’s working and copy & paste the GA information in the same order (provided you're using the same GA property and view). Remember, the information has to exactly like it appears in GA.
After that, you save the file in the text editor and reopen it in Tableau. Go to edit data source and it should work. You may need to reset the connection or you may get a warning that the access token is not valid, but, you just need to allow permission again.
Hope this works for you. It did for me.
DISCLAIMER: Manually editing the XML file can cause irrevocable damage to your workbook so please make a copy of your Tableau workbook before trying this fix!!!