Looking for guidance on designing an Azure data analytics pipeline for reporting

I’m working on modernizing an old reporting workflow that currently runs on a few on-premises databases and scheduled scripts.

The current process collects operational data from multiple systems, performs some basic transformation and aggregation, and then generates reports for different business teams. As the data volume is growing, the existing setup is becoming difficult to maintain and slow to refresh.

I’m looking for an Azure-based architecture that can ingest data from different sources, store both raw and processed data, run scheduled transformations, and make the final datasets available for reporting tools like Power BI.

Would appreciate any suggestions on the recommended architecture, especially around data storage, transformation, refresh performance, and cost control.

Thanks