We have created an Azure logic app layout which is invoked through an HTTP request along with a zip file sent across as a binary body.
Inside the azure logic app, the file is passed to Azure Function (Python environment) where it undergoes ETL operation to produce a final CSV which is then saved in SharePoint and imported to PowerBI through SharePoint link. And finally Power BI produces PDF reports which is shared returned as a binary response.