It's possible that you may be running into something caused by Shadow Extracts. More info here, but in a nutshell, when you connect to an Excel file, Tableau creates a shadow copy of it as an extract and stores it in a different folder. When you update the real data source, the viz in Tableau doesn't update because it's still pointing at the shadow location, which hasn't changed.
I'm not really an expert in how Tableau Server integrates with Sharepoint, but I wonder if you might try establishing the Powerpivot Excel file as a published data source on Tableau Server, then connecting to that, creating your viz, and publishing that version of the workbook. The idea being that when you refresh it within Tableau Server, Server will be able to go back to the original location and read the new data.
I hope this gives you a good lead! If your question is resolved, please mark a response as the correct answer. Thanks!
thank you for your suggestion. I have tried both
- publishing my sharepoint connection to tableau server
- saving connection as a .tds file and publishing the tds file to tableau server
for both methods, when I tried connecting to this published datasource using tableau desktop, it prompted me to download a local copy.
I don't think I can use the published datasource method you suggested.
I have the same problem. I was wondering if you found a solution to this. I could resolve Desktop related problem based on the link provided in this forum. But I couldn't resolve Server related config.