Is SQL Server Express edition (2014) not supporting compression at all ? (Is it necessary to upgrade to enterprise edition)
With Express Edition, you need SQL Server 2016 SP1 or later to support data compression. In earlier versions, you need Enterprise (or Developer for testing). The documentation below detail the features that may vary by SQL Server version and edition:
SQL Server 2014 Features by Edition