I have a macro enabled workbook that opens each morning, refreshes 5-10 power queries and outputs those as a single table that is just under 1mm rows to a csv. That csv is essentially a database that feeds into other workbooks and SaaS platforms.

The sheet is getting too big and lately the automated act of pasting to the csv crashes before the job can finish. I've been doing it manually when that happens.

All of the data is being loaded into a data model / powerbi before its exported to the worksheet csv. I want to bypass the creation of the csv and load directly from my data model into a database like MySQL or Azure. I dont know much about Azure so i'm looking for suggestions as to how I can do this in an automated fashion without ever having to move the data out of the data model.