In the context of a real electrical distribution network in Puerto Carreño, Colombia, this paper addresses the challenge of enhancing power supply reliability through the strategic integration of Renewable Energy Sources with Hydrogen Energy Systems. The planning problem is reformulated as a Mixed-Integer Quadratically Constrained Programming problem, enabling the use of efficient solvers with global optimal solution. Considering the extensive curtailment options and numerous allocation components, the optimization problem naturally scales up. To address this computational intensity, representative scenarios are derived from the original high-dimensional probability distribution employing the Gaussian Mixture Model. These scenarios are used in conjunction with the proposed optimization framework to achieve cost-effective power grids while reducing fossil fuel dependency.