@Elios Your best choice here is using Power BI Report Builder (paginated reports) and Power Automate to export the report.
Check my latest blog post Compare Budgeted Scenarios vs. ActualsI would ❤Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Did I answer your question? Mark my post as a solution.
Proud to be a Super User! Appreciate your Kudos🙂 Feel free to email me with any of your BI needs.