Description:
In Qlik NPrinting Designer when previewing an Excel report with Pivot Table columns an error appears that the data source is not supported.
Steps to Reproduce:
- Add a Straight Table to a Qlik Sense App
- Create the App Connection in Qlik NPrinting
- Create an Excel Report
- Click Edit Template to Launch Qlik NPrinting Designer
- Follow the Help Documentation: Creating Pivot Table Using Excel Table Columns
- After the Step "Summarize with Pivot Table in the tools group"
- Enable the "Add this Data to Data Model" checkbox
- Click OK
- Preview Report
Log Files show:
20191010T194633.201+02:00 WARN QLIKSERVER1 0 0 0 0 0 0 0 0 Exception handling production request bf8964f9-5762-42c5-bcd2-8e1b8eb15cdd. ERROR: Aspose.Cells.CellsException: this data source is not supported.??
Environment
- All supported versions of NPrinting
Resolution:
- Unfortunately that specific Microsoft Excel functionality that is related to the creation of Data Models in a Excel Workbook and Linked tables is not supported.
For the latest on this, please check the following Qlik NPrinting help page to check if support for this option has changed