Hi @lakeshore,
It's unfortunate that there is no way could reproduce the file size, as a workaround, you could reproduce some unnecessary columns in the PowerBI reposts or separate the reports into serval times to export.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.