Forum Discussion
How to export an Excel file (not CSV) via Power Automate button?
The limit is elsewhere - the size of the Base64 encoded string.
You can create the Excel file and table directly and then you can use the Graph API to batch upload rows into the table.
Note that your flow action seems to be decoupled from your Power BI user experience. Make sure you include the expected filters in your DAX queries.
Sorry shouldn't I be creating the excel table after running the query? Since the table needs to contain the contents of the Power BI query? Also you have included a post action whereas I actually need to create an xlsx file.
Please check my screenshots again. The first two steps create the Excel file.
Then it is a matter of preference what you do first. But assuming you need to run multiple queries (to avoid hitting the row limit) then creating the table first makes more sense.