When creating your Pivot Table select "Add this data to the Data Model".
After creating the Pivot Table make sure that in Pivot Table Options "Show items with no data on rows" isn't selected.