cannot add a field to values section on a pivot table in Excel

I am trying to create a pivot table from an Access database connected to PowerBI. Sadly I can't add any field to the values area as I keep getting the error "The field you're moving cannot be placed ...