I seem to be having the same problem as the following post:
I've tried restarting server, and while it seems to free up the Excel file, when I refresh from Server, I get the same problem again.
Hi Alex -
I recently had a similar issue and posted here Is there any way to find if tableau server having lock on excel file used for extract refresh?
We're currently running 8.2.2. There is a known issue in this release (and others as well) where .xls datasources hosted on a network drive were locking up and preventing extracts from refreshing. We were advised by Tableau customer support to upgrade... I think we'll be moving to 8.3.6 in the very near future.
Not sure if this applies to your issue but would probably be worth exploring.
Hope this helps!
We're on Server v9.0.1, so it can't be that, unless it's still an issue in later versions.
Thanks for the suggestion though, nice to know it's not just us!
Is the Excel file within SharePoint? Or is it truly on a network drive that has NO association with SharePoint?
Continuing from this thread Re: Is there any way to find if tableau server having lock on excel file used for extract refresh?
Alex Lea wrote:
Thanks for the reply. I've found the following KB article on setting isolation levels, which should help get around the lock issue.
I've forwarded it to our ICT team and will do the same with your article on SharePoint.
Many thanks, much appreciated.
I doubt setting the isolation level will work but if I'm wrong then I'd LOVE to know exactly how you implemented it. These may or may not help your IT people:
I know they deal with DB2 and MS SQL but the concepts are the same.