Something's not quite right about your data – it can't be displayed in Excel. Column 'id' does not allow nulls. (Release 7)
Error Message
Something's not quite right about your data – it can't be displayed in Excel. Column 'id' does not allow nulls.
Cause
The Conga View Data Workbook generates an Excel workbook based on the dataset supplied to Conga in your solution. This error occurs when the dataset supplied to Conga is empty. There are a variety of reasons that can cause this such as:
- A poorly formed query can filter out all data resulting in an empty dataset
- A Salesforce report that filters out all data
- Permissions that do not allow the user running the solution to see the required data
What to Do
- Review your data for null values (ensure every record in your report has an ID)
- Test on a different record
- Run your Salesforce report outside of Conga Composer (by entering your record ID in the first filter on the report)
- Unless you are using Mail Merge or Conductor, remove the ID column from your report