KNOWLEDGE BASE

Error "Database error: No value given for one or more required parameters"


Published: 07 Apr 2017
Last Modified Date: 07 Apr 2017

Issue

After connecting to an Excel data source, you might see the following error message: 

"Database error 0x80040E10: No value given for one or more required parameters."

 

Environment

  • Tableau Desktop
  • Excel (older versions)
  • Access

Resolution

The error can occur for one of the following reasons:

  • A column requested by a custom SQL statement does not exist in the Excel data. To resolve this issue, remove the column from the custom SQL statement.

  • When connected to Excel data, Jet cannot send one or more of the column headers in the Excel file to Tableau because there are leading or trailing spaces in the data. To resolve this issue, remove the leading or trailing spaces from the Excel file to allow Jet to send the column information to Tableau.


In the following example, the Quantity field in the Excel data contains leading spaces. 

Tableau cannot connect to the spreadsheet because of the leading space in the "Quantity" column header. When you begin to drag dimensions and measures into the view, you might see the error message.

Note: This type of Jet-based errors can only occur under one of the following circumstances:

  • The workbook was created in Tableau Desktop 8.1 or earlier versions and use Excel 2007 or text file data sources.
  • Workbooks that use the legacy data connection.
  • Workbooks that use Microsoft Access data sources.


To avoid Jet-based issues, consider upgrading your Excel data source.  

Cause

This error message appears because of limitations in the Microsoft Jet Database Engine. 
Did this article resolve the issue?