Exporting Multiple Tables to Excel/CSV Automatically

Hi Anonymous 

The limitation comes from how the Power BI engine works — each visual on the report page is based on a separate query.
That’s why there isn’t a single built-in action to export all visuals together in one go.

You have two possible approaches:

Create a Power Automate flow for each visual (table) – since each one runs its own query, you’ll need a separate process for each export. You can also use a parent flow that triggers 9 child flows to make it easier to maintain.

Use one of the alternative methods mentioned earlier –

A Paginated Report (RDL) that includes all tables and can be exported to Excel/CSV automatically.

Or a dataset query flow that runs DAX queries for each table and writes the results to Excel/CSV in SharePoint or OneDrive.

There are no “magic buttons” to export multiple visuals automatically at once — every visual is handled independently by the engine, so the automation must reflect that.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly