The following error may occur when reloading data from Ms Excel: “Error: Too many columns in data source (16326) but the limit is 10000."
Resolution
Defect QB-22272 reported to R&D
This was an intentional change introduced in Qlik Cloud but was obviously set as a default limit for Qlik Sense Enterprise for windows as well.
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-22272 for reference.
Workaround:
As workaround, please add this parameter "MaxColumnsInDataSource=0" in "settings.ini" file
1. Stop Qlik Sense Engine service
2. Edit "settings.ini" file from C:\ProgramData\Qlik\Sense\Engine
3. MaxColumnsInDataSource=0 and save "settings.ini" file
4. Restart Qlik Sense Engine service and test
Fix Version:
R&D is planning to turn back as it was before the latest release but I can't predict the version in which a fix will be available.
Cause
Product Defect ID: QB-22272
Environment
- Qlik Sense Enterprise May 2023 and above
- Qlik Sense Cloud
