Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : wowhYYPSJ+Lm2rwyJ6Ne+L
Power Platform Community / Forums / Power Automate - Building Flows / Export Power BI data /...
Power Automate - Building Flows
Suggested answer

Export Power BI data / CSV to Excel Table

Like (0) ShareShare
ReportReport
Posted on 17 Feb 2025 20:38:53 by PowerApps01 13
Hi,
 
I have managed to create a Power Automate flow that exports Power BI data to CSV but the requirement is now to do this for Excel - Power BI data to be exported to an Excel table but I haven't managed to find anything on this other than Reza Dorrani (https://www.youtube.com/watch?v=cT4JdClkLh8), but this flow is created within Power BI Desktop/Service using the Power Automate visual but I need to create it outside of Power BI Desktop/Service (i.e. without using the Power Automate visual).
 
I have the run a query against a dataset within the Do Until loop (following Curbal's video on getting back over 100,000 rows but this is only for CSV):
 
 
The Add a row into a table action requires me to input something for the Row, not sure what. If I can either export from Power BI to Excel table or from CSV to Excel table, I'm good with either. I've been at this for the past couple of weeks or so and any assistance is greatly appreciated.
Categories:
Business Process Flows
  • lbendlin Profile Picture
    lbendlin 7,799 Super User 2025 Season 1 on 21 Feb 2025 at 22:30:21
    Export Power BI data / CSV to Excel Table
    Not sure which expressions you are talking about - please clarify.
     
    I don't see a Power Automate option without a premium connector but you can do all this and more in PowerShell too.
     
    Slow as in 10 rows per minute slow.
  • PowerApps01 Profile Picture
    PowerApps01 13 on 21 Feb 2025 at 10:14:40
    Export Power BI data / CSV to Excel Table
    Thanks for your response @lbendlin.
     
    Could you expand on the 3 expressions you used?
     
    By the way, this is a premium connector, do you have a solution that doesn't use a premium connector?
     
    When you say method 5 is extremely slow, how slow are we talking?
  • lbendlin Profile Picture
    lbendlin 7,799 Super User 2025 Season 1 on 21 Feb 2025 at 01:20:05
    Export Power BI data / CSV to Excel Table
     
    Method 5 technically works but is extremely slow. "RBAR".
     
  • PowerApps01 Profile Picture
    PowerApps01 13 on 20 Feb 2025 at 09:57:32
    Export Power BI data / CSV to Excel Table
     
    Thank you for your response.
     
    Could you expand the Select Result Values action please? And what are the full expressions used in the Url of the request? Could you also provide more detail on your Method 5? Many thanks.
  • lbendlin Profile Picture
    lbendlin 7,799 Super User 2025 Season 1 on 20 Feb 2025 at 01:20:21
    Export Power BI data / CSV to Excel Table
    Method 6:  Use the Graph API and Batch processing to load the Power BI data directly into the Excel table, quickly, with no intermediate steps.
     
  • PowerApps01 Profile Picture
    PowerApps01 13 on 19 Feb 2025 at 14:40:20
    Export Power BI data / CSV to Excel Table
    Hi @AlexEncodian,
     
    Thank you for your response.
     
    Unfortunately that's not an option.
     
    Kind regards,
    Mohamed
  • PowerApps01 Profile Picture
    PowerApps01 13 on 18 Feb 2025 at 09:36:34
    Export Power BI data / CSV to Excel Table
    Hi @Robu1,
     
    Thank you for your reply.
     
    For method 5, I don't understand what you mean by using a JSON object to define the Excel table, is there a video or some material that I can read which you can direct me to?
  • Suggested answer
    Robu1 Profile Picture
    Robu1 1,202 Super User 2025 Season 1 on 17 Feb 2025 at 22:11:46
    Export Power BI data / CSV to Excel Table
     
    Thank you for choosing Microsoft Community.
     
    Exporting Power BI data to an Excel table without using the Power Automate visual in Power BI Desktop/Service can be a bit tricky, but it's definitely possible.
     
    Here are a few methods to explore:
     
    Method 1: Using Power Query
    Open Power BI Desktop: Load your Power BI file.
    Go to the Data view: Select the table you want to export.
    Copy the table: Right-click on the table and select "Copy Table."
    Paste into Excel: Open Excel, select a cell, and paste the copied table.
     
    Method 2: Using DAX Studio
    Install DAX Studio: Download and install DAX Studio.
    Connect to your Power BI model: Open DAX Studio and connect to your Power BI model.
    Run a query: Use DAX Studio to run a query against your dataset and export the results to Excel.
     
    Method 3: Using Power BI Exporter Tool
    Download Power BI Exporter: Get the Power BI Exporter tool.
    Run the tool: Use the tool to export your Power BI data directly to Excel.
     
    Method 4: Using Power BI REST API
    Set up the API: Configure the Power BI REST API to access your dataset.
    Run a query: Use the API to run a query and export the results to Excel.
     
    Method 5: Using Power Automate (Outside Power BI)
    Create a Power Automate flow: Set up a flow that connects to your Power BI dataset.
    Run a query: Use the "Run a query against a dataset" action to get the data.
    Add a row into a table: For the "Row" input, you can use a JSON object to define the structure of your Excel table.
     
    I hope one of these methods helps you achieve your goal! If you need more detailed steps or run into any issues, feel free to ask. I'm here to help!
     
    If this resolves the issue, kindly mark it as resolved to enable others find this solution.
     
     
    Kind regards,
    Robu1

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,700 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans