Power BI is excellent for governed reporting. Python shines when you need statistical depth ??? elasticity estimates, clustering, or custom forecasts that do not fit neatly into a visual.
The winning pattern is hybrid: curated data in Azure, exploratory and advanced analytics in Python, and executive storytelling in Power BI.