Supportive policies for energy sharing promote collective mechanisms within renewable energy communities (REC). Recent updates to the European renewable energy framework require Member States to revise incentive mechanisms, shaping new opportunities for  collective self-consumption. In urban contexts, while residential functions dominate, mixed-use neighborhoods offer opportunities to integrate load patterns that can enhance the local use of renewable generation. The refinement of occupancy behaviour impact on simulations of energy demand and energy-sharing benefits. This study investigates the energy and financial viability of establishing a solar REC in an urban mixed-use district in Bari, Italy. The analysis considers archetypal residential, commercial, and service-sector buildings. Residential occupancy patterns by household types are defined from census data and time-use survey. Rooftop photovoltaic systems are simulated to meet part of the electricity demand,  using self-consumption and self-sufficiency indicators. The energy-related and financial impacts of two collective self-consumption schemes—a multi-family housing models and a virtual energy-sharing model for the community—are compared. The results demonstrate that a solar REC enhances local self-consumption by 10% and self-sufficiency by 4% compared to the single-building scenario, matching different demand profiles. However, annual revenues from energy-sharing incentives remain limited for each member. The evaluation highlights the benefits of RECs supporting urban energy transitions and inform policy design for more effective energy-sharing frameworks.