A retail company operates several transactional systems: an on-premises SQL Server, an Azure SQL Database, and a SaaS CRM exposed only through a REST API. Analysts need a governed, code-optional way to ingest and transform data from all three sources on a scheduled basis, land it in a data lake, and then run large-scale analytical queries and Power BI reports. The team has limited engineering resources and wants to minimize infrastructure management while supporting orchestrated pipelines with a visual authoring experience. Which combination of Azure services should you recommend?