Priti- It's hard to say what's going on with your data source without actually looking at it. However, I have couple questions,
1) Is the published data source live or an extract? If it is an extract, when was it last refreshed?
2) If the said published data source is an extract, was created using some 'Extract filters' that's filtering out data? If it is live however, I'd see if it has any data source filters.
I'd primarily check any filters or field changes between your local copy vs published data source.
I have filter on the years. both datasource has same filters. when I tried to refresh the extract or do the live connection I get the error "Unexpected error" Internal error - an unexpected error occurred and the operation could not be completed. somehow it is not refreshing.
Would you know when was the extract last updated? There could be multiple reasons why you're getting the error.
Is the extract refresh running fine on Server? What version of Server/Desktop are you on?
Thanks for your reply Shiva.
the extract on the server updated last night and everything is correct on the server. I'm on Tableau Server 10.4.1 and my desktop version is the same.
When I update/extract on my desktop it is throwing the error and then connected with insufficient data.
Thanks for your help.