What is a common mistake with projection to DTOs in Entity Framework Core?

Loading full entities and mapping them in memory wastes resources for list and reporting endpoints.