Pivot Table and SQL Database

[Erika]

I have a SQL database that I am trying to get to connect to a pivot table. I
have the connection working I can pull the information into a Pivot table
however the drop down boxes on the fields do not populate. They are empty.