Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Exporting Multiple Tables to Excel/CSV Automatically

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

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 months ago

      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's avatar
        Ritaf1983
        Super User
        9 months ago

        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.