I am experiencing an issue with a scheduled extract refresh on Tableau Server.
Setup:
- Workbook is saved as .twb.
- An Excel data source is joined with our Finance DataMart.
- The Excel file is connected using a UNC path:
\\afcu-nas1\Vol1
The workbook publishes successfully and can be accessed by users.
Error:
Plain Text
1
Connectionless Failure (status code = 10000)
2
3
One or more connections in this data source need attention:
4
AZ Financial Daily Dash - FRB: Unable to connect to the file
5
"FAKEPATH-0bb8dbj1xzpc3f15h22kp1cqe5lv".
6
7
Check that the file exists and that you have sufficient access privileges for it.
Show more lines
Could you please help us understand:
- Why Tableau is attempting to access a FAKEPATH instead of the configured UNC path?
- Whether additional server permissions or configuration are required for scheduled refreshes against an Excel file on a network share?
- Any recommended steps to resolve this issue and enable automated refreshes?
Hi @Neel Maniar
The FAKEPATH in the error is an internal temporary path generated by Tableau Server. It doesn't necessarily mean that Tableau is replacing your configured UNC path.
Please try the following:
- Add the UNC path to the Tableau Server allowlist: After recent security updates, file-based data sources may require the network path to be allowlisted.
- Check Tableau Server Run As account permissions: Ensure the account running Tableau Server has read access to the Excel file and the network share.
- Verify the UNC path: Make sure the connection uses the complete UNC path, including the Excel file name, and not a mapped drive.
- Republish the workbook: Use the correct UNC path in Tableau Desktop and uncheck Include External Files before republishing.
- Test the scheduled refresh after completing the above steps.
You can refer to the official Tableau documentation:
https://help.tableau.com/current/server/en-us/security_harden.htm
Hope this helps!
If you find this response helpful, please mark it as the Accepted Answer, as it may also help other Trailblazers.
