Qlik Sense：使用Data manager时无法通过"Select data from source"加载表求助

I’ve run into this exact inconsistency a few times with Qlik’s Data Manager—preview working but full load failing is usually a permission, script, or cache-related issue. Here are the most actionable fixes to try:

• Check Source Connection Permissions
  Even though you can preview data, the full load process often requires broader permissions than a limited preview. For database sources: confirm the Qlik service account has full SELECT access to the target table/view (not just the subset pulled for preview). For file-based sources (like CSV/Excel): ensure the Qlik service account has read + directory traversal permissions on the file’s parent folder—preview might only need access to the single file, but the load workflow may scan the directory for validation.

• Inspect the Auto-Generated Load Script
  Data Manager’s auto-generated scripts sometimes hide subtle syntax errors or conflicting filters that don’t show up in preview. Here’s how to check:

  1. Switch to the Data Load Editor (use the dropdown in the top-right corner of Data Manager)
  2. Locate the script block marked // Auto-generated by Data Manager
  3. Look for typos in field names, invalid WHERE clauses, or incorrect references to your data source
  4. Test a minimal manual script (e.g., LOAD * FROM [YourSourceTable] (qvd); or the appropriate database connection string) to confirm if the source itself is loadable outside Data Manager’s auto-flow

• Clear Qlik App Cache and Temporary Files
  Cached metadata can cause preview and load to behave differently. Try this:

  • Close your Qlik client (Sense/View) completely
  • Navigate to Qlik’s temp directory (for Qlik Sense, this is typically C:\ProgramData\Qlik\Sense\Repository\Temp)
  • Delete the cache folder associated with your problematic app
  • Reopen the app and attempt the "Select data from source" load again

• Test for Corrupt Records or Data Type Mismatches
  Preview only loads a small sample of data—full load might hit a corrupted record or data type conflict that’s invisible in the sample:

  • In Data Manager’s preview screen, try loading the entire preview dataset (if the option exists) to see if it fails
  • Check the source data for special characters, unexpected nulls, or fields with values exceeding Qlik’s default length limits
  • Try loading a single field or a filtered subset of data (e.g., add a WHERE clause to limit rows) to narrow down which record/field is causing the failure

• Validate Data Manager’s Load Configuration
  Double-check if your Data Manager settings are causing a conflict:

  • If you’re using incremental load, confirm the incremental key (like a timestamp or ID) is correctly configured—misconfigured incremental logic can block full loads
  • Review any custom data transformation rules you’ve applied; some rules work fine in edit/preview but fail during the full load execution

内容的提问来源于stack exchange，提问作者Hari