>If some users are accessing SQL Server database from SSMS, while others are accessing it from Power BI desktop, is SQL Server Standard license ok or an Enterprise version is required?

Standard is *likely* OK, unless you are doing something else beyond Standard licensing.

But what you described, in itself, is not a requirement for Enterprise