10 Replies Latest reply on Sep 30, 2016 2:12 AM by fanny.gmail

    Unable to refresh Excel extract on Tableau Server

    fanny.gmail

      Hello Tableau Community,

       

      I'm trying to refresh an extract (based on an Excel file) on Tableau Server.

      The Extract refresh works well on Desktop but I always got the following error on Tableau Server :

      "com.tableausoftware.nativeapi.dll.DataSourceException: Unable to connect to the file "C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp\TableauTemp\0f8v4uw0xrv65l190auql0oexr0c".

      Check that the file exists and that you have sufficient access privileges for it."

       

      Note that :

      • Microsoft Access Database Engine 2010 driver is installed on server
      • The 'Run as' user has the rights access to the shared folder where the excel file is stored
      • The file  "C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp\TableauTemp\0f8v4uw0xrv65l190auql0oexr0c" really not exists ...
      • Excel data connection use UNC path

       

      Please suggest if you know what I am missing or how do I fix this issue.

       

      Thanks

      Fanny