12 Replies Latest reply on Oct 11, 2015 4:25 PM by Karen Huang

Function refreshDataAsync() does not refresh the view

Karen Huang Sep 21, 2015 12:07 AM

Hi,

Got a task to refresh a real-time sheet which can be viewed via browser. Googled the Internet and copied a number of scripts but none works on my pc. I have the following codes in the script:

...

function RefreshViz(){
    alert("test");
    viz.refreshDataAsync();
    }

...

The function alert() works as a dialog box pops up:

However refreshDataAsync() does not seem to work as the view doesn't get updated.

This morning I stopped the Tableau service for some other reason whilst still having the htm file with the javascript running on Chrome. And I got this:

It seems a request was sent to the server! Then why didn't the view get updated? I tried on IE8, Chrome 45 and Firefox22.

Any idea would be appreciated.

Karen

1. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 22, 2015 1:22 PM (in response to Karen Huang)

I had a difficult time with this as well. Are your data sources live or extract? Also, have you checked that you are able to refresh the data sources from outside the API?
Like Show 0 Likes(0)

Actions
2. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 22, 2015 4:40 PM (in response to Jerry Daru)

Hi Jerry,

It's live data with a connection to a SQL database. The dashboard can be refreshed either on Tableau Server or in its workbook. I can manually refresh the browser to get lastest data shown in the charts.

How did you fix your problem??

Thanks.
Like Show 0 Likes(0)

Actions
3. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 23, 2015 11:37 AM (in response to Karen Huang)

For me the fix was to change our server settings to not use cached data for our live data sources
Like Show 0 Likes(0)

Actions
4. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 23, 2015 4:28 PM (in response to Jerry Daru)

I did it too. By default the Caching setting on our Tableau Server was 'Balanced' and was changed to 'Refresh more often'. But the refreshing problem is not fixed.

Thanks Jerry. There might be other issue in my Tableau environment. ...
Like Show 0 Likes(0)

Actions
5. Re: Function refreshDataAsync() does not refresh the view

Jerry Daru Sep 29, 2015 9:18 AM (in response to Karen Huang)

Are you using the trusted ticket method for accessing the data? Or, are you depending on the log in credentials of the person accessing the page?
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
6. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Sep 30, 2015 7:52 PM (in response to Jerry Daru)

No Jerry. At the moment we are not using trusted authentication, but user credentials to access Tableau Server.

Cheers,
Like Show 0 Likes(0)

Actions
7. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 2, 2015 8:47 AM (in response to Karen Huang)

When you open your chrome's web inspector, do you see any javascript error? can you check your XHR queries and responses in network tab? are the related AJAX calls are successful?
Like Show 1 Likes(1)

Actions
8. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 4, 2015 10:19 PM (in response to Tamas Foldi)

Thanks Tamas. A couple of errors were found in my javascript codes which I copied from Internet: (1) tableau_v8.js file was not included in the html file; (2) non-existing tableauSoftware.viz() constructor instead of tableau.viz() was used to create a viz object.

However, after trying to fix them, I've attracted new errors. Seems an array, tableau.vizs[ ], is not defined in viz_v1.js? Not sure if it was due to a failed step where the array was to be created...

regards,
Like Show 0 Likes(0)

Actions
9. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 4, 2015 10:26 PM (in response to Karen Huang)

you should not include viz_v1.js directly, just tableau v8 js which declares that array.

could you post your current state of code?
Like Show 0 Likes(0)

Actions
10. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 4, 2015 10:39 PM (in response to Tamas Foldi)
Hi Tamas,

You are right. By removing viz_v1.js there is only one error left.

The htm file is attached. You need to change its file extension. As well as the link to the Tableau dashboard to be something local...

Thank you.

LivePunctRefreshScript.txt.zip 958 bytes
Like Show 0 Likes(0)

Actions
11. Re: Function refreshDataAsync() does not refresh the view

Tamas Foldi Oct 10, 2015 4:28 AM (in response to Karen Huang)
I fixed for you, find it attached.

This was the main issue:

window.setInterval(RefreshViz, 1000);

Here you should not use quotes when specifying the callback function.

LivePunctRefreshScript.txt.zip 753 bytes
Like Show 0 Likes(0)

Actions
12. Re: Function refreshDataAsync() does not refresh the view

Karen Huang Oct 11, 2015 4:25 PM (in response to Tamas Foldi)

Thanks Tamas. I see the problem. Now it works on my pc too.

Appreciate of your help. I spent quite some time trying to debugging this.

All the best.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Function refreshDataAsync() does not refresh the view

1. Re: Function refreshDataAsync() does not refresh the view

2. Re: Function refreshDataAsync() does not refresh the view

3. Re: Function refreshDataAsync() does not refresh the view

4. Re: Function refreshDataAsync() does not refresh the view

5. Re: Function refreshDataAsync() does not refresh the view

6. Re: Function refreshDataAsync() does not refresh the view

7. Re: Function refreshDataAsync() does not refresh the view

8. Re: Function refreshDataAsync() does not refresh the view

9. Re: Function refreshDataAsync() does not refresh the view

10. Re: Function refreshDataAsync() does not refresh the view

11. Re: Function refreshDataAsync() does not refresh the view

12. Re: Function refreshDataAsync() does not refresh the view

Actions

More Like This