Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Qlik NPrinting September 2019 Excel Reports with Pivot Table Columns Preview Data Source is Not Supported

Sonja_Bauernfeind
Digital Support
Digital Support

Qlik NPrinting September 2019 Excel Reports with Pivot Table Columns Preview Data Source is Not Supported

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:

  1. Add a Straight Table to a Qlik Sense App
  2. Create the App Connection in Qlik NPrinting
  3. Create an Excel Report
  4. Click Edit Template to Launch Qlik NPrinting Designer
  5. Follow the Help Documentation: Creating Pivot Table Using Excel Table Columns
  6. After the Step "Summarize with Pivot Table in the tools group"
  7. Enable the "Add this Data to Data Model" checkbox 
  8. Click OK
  9. Preview Report

User-added image


User-added image

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

Version history
Last update:
‎2021-07-22 11:39 AM
Updated by:
Contributors