web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Bi - export data
Power Automate
Suggested Answer

Power Bi - export data

(2) ShareShare
ReportReport
Posted on by RF-21041750-0 2

How to export data using table from power bi?

Categories:
Building flows
I have the same question (0)
  • Suggested answer
    Jon Unzueta Profile Picture
    Jon Unzueta 1,834 Super User 2026 Season 1 on at
     

    To export data from a table visual in Power BI, you have several options depending on your needs and permissions. Here's how you can do it:

    ✅ Option 1: Export from Power BI Service (PowerBI.com)

    1. Go to your report in the Power BI Service.
    2. Click on the table visual you want to export.
    3. Click the ellipsis (...) in the top-right corner of the visual.
    4. Select “Export data”.
    5. Choose the format:
      • CSV (default)
      • Excel (if enabled by your admin)
    6. Click Export.

    🔒 Note: Export options may be restricted by your Power BI admin or dataset settings (e.g., if the data is from a DirectQuery source).

    ✅ Option 2: Export from Power BI Desktop

    Power BI Desktop does not support direct export from visuals. However, you can:

    • Use DAX Studio to export data from a table or model.
    • Use “Copy Table” from the Data view:
      1. Go to the Data view.
      2. Right-click the table → Copy Table.
      3. Paste into Excel.

    ✅ Option 3: Use Paginated Reports (for formatted tables)

    If you need formatted tables with headers, consider using Paginated Reports in Power BI Report Builder:

    • Connect to your semantic model.
    • Design a table layout.
    • Export to Excel, PDF, etc.

    ✅ Option 4: Use Power Automate to Export Data

    You can automate export using Power Automate:

    • Trigger a flow from Power BI.
    • Use Power BI connector to get data.
    • Write to Excel or SharePoint.
     
    🏷️ Tag me if you have any further questions or if the issue persists.
    ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.
    ❤️ Give it a Like if you found the approach useful in any way.
  • WillPage Profile Picture
    WillPage 2,335 Super User 2026 Season 1 on at
    In PBI Desktop, add a table visual with all the columns and filters you want. Then use the performance analyzer (Tools ribbon) to get the DAX query for the table. Now in Power Automate, you can use the action called Run a query against a dataset.

    Publish your report then paste the DAX from PBI desktop performance analyzer in there and you'll get the same data when you run the flow. You can substitute filters in the DAX with dynamic content. The response is JSON which you can process in Power Automate just like data from SharePoint or anywhere else. Uses standard license in Power Automate and Pro license in Power BI.

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

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 815

#3
Haque Profile Picture

Haque 630

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans