'sql connection to populate table condenses rows

I have an Excel sheet that has a connection to SQL server to generate some table data into the spreadsheets. There is a strange issue where the spreadsheet gets populated, but some rows are condensed with height of 0. What is causing this issue?

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source