A possible solution is to use Azure Data Factory (ADF) to upload data to an Azure SQL Database (PaaS) as explained here and then use Power BI to connect to the Azure SQL Database, and read the consolidated data for creating a report/dashboard in Power BI.
You can even create an Azure Logic App to trigger execution of an ADF pipeline if an event occurs like a new file arrives into Azure Storage Account or a new records is added to a table as explained on this video.