1 Reply Latest reply on Jun 7, 2018 12:17 AM by Sankarmagesh Rajan

    Refresh Error on server With Excel File

    balan view

      Hi,

       

      I am using teradata datasource and Excel in my dashboard. While refreshing i am getting below error. pls help on that.

       

      com.tableausoftware.nativeapi.dll.DataSourceException: Unable to connect to the file "C:/Users/pmm911525/AppData/Local/Temp/TableauTemp/1806324550/Data/bala/Excel.xlsx". Check that the file exists and that you have sufficient access privileges for it.

       

       

      Regards

      Bala

        • 1. Re: Refresh Error on server With Excel File
          Sankarmagesh Rajan

          Hi Balan

           

          Resolution

          • Check to ensure that the file is still in the expected location.
          • Update the data connection(s) in Tableau Desktop to reflect the UNC path to the Excel workbook, instead of a file path that includes a mapped drive letter, and republish the workbook.
          • Ensure that the Tableau Server run as user has access to the location where the file is being stored.

          To test whether the Tableau Server run as user has access to the file location, log in to the computer running Tableau Server as the 'Run As' user and attempt to access the folder where the file is stored, using the UNC path in a Windows File Explorer window.

           

          Cause

          The file has been moved or deleted, or the Tableau Server Run As user does not have access to the location where the file is stored. This can be because the path used to connect to the data source is a mapped path.  Because the Run As user account cannot access resources that have been authenticated in the security context of another user, it cannot use the mapped path.