How to Export Data from a Specific Table in Power BI Report or Dashboard
Learn how to export data from a specific table within PowerBI from a report or dashboard.
Step 1: To Export data from a specific table in any report to an Excel or CSV, you have to first hover your cursor over the table. When you hover, you will see an ellipsis appear in the top right corner (highlighted below - this can sometimes be hard to see, but you must carefully hover on the actual table of data you want to export).
Note that there may be multiple data tables on an individual report.
Step 2: After you see the ellipsis in the top right corner of the table, you can click on it and select Export Data.
Step 3: This will prompt you to choose your export type (both are not always available) Data with Current Layout or Summarized Data. For all purposes, these are the same, although the summarize data option will allow you to export 500,000 rows, and the current layout will allow 150,000 rows.
Experiencing an issue or need additional support? Contact our OneIT Team by
Opening a support ticket or
Calling us at 201-216-5500