Exporting Multiple Tables to Excel/CSV Automatically

[Jamesfindog]

Hi All,

I have a simple report which contains many tables (9) within a single sheet.

Each of these tables needs to be exported to Excel on a daily basis, and I was just wondering if this was able to be automated?

For extra info, the tables are from a variety of datasources including: 
SharePoint

Semantic Models

Live ODBC Connections

Cheers

[Ritaf1983]

HI @Jamesfindog 
Yes it achievble with power automate.
Please refer to the linked video guide:
https://www.youtube.com/watch?v=ZTkbC8zhA5k

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

[Jamesfindog]

Hi mate.

I have found this previously.

This is just for a single table, I am looking to export all tables in one go.

Cheers.

[Ritaf1983]

To export multiple tables automatically, you have two main options:

1. Paginated Reports (recommended if you have Premium/PPU)
   Create a paginated (RDL) report that includes all 9 tables and use a Power Automate flow or a subscription to export it to Excel or CSV daily. This is the cleanest solution for exporting multiple tables in one file.

2. Power Automate + Dataset Query
   Build a flow that runs DAX queries against your dataset using the “Run a query against a dataset” action.

   • Each query can return one table.

   • You can use a loop or child flow to handle all 9 tables automatically instead of creating 9 separate flows.

   • The results can be written to CSV or Excel files in SharePoint or OneDrive.

[Jamesfindog]

So, not possible at all?

[Ritaf1983]

Hi @Jamesfindog 

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