How to export data from a specific table in Power BI report/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 that 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 for 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.
