Power BI data export

We have a requirement to export data to an Excel, but there is a limitation of 150,000 rows.  I have seen an option by "DAX Query with Email/create file in Sharepoint" flow using Power automate. But ...