Forum Discussion
Export dataset - table to Excel
I am trying to export some table - datasets (created with query from a db) to Excel.
I have seen the option you can see in the image, 'copy table', but apparently it does not work when I try
paste to Excel
thanks
Hi perpor,
It's the known issue that the Copy Table function doesn't work in latest Power BI desktop version, you can see this thread.
When you use Copy Entire Table in Query Editor, it will copy data which are loaded in the table, it means you need to scroll down to load all table data, then use this feature to copy and paste whole table.
Also you can try to use table visual to show data from that table, then use Export Data feature.
As the table comes from the database, you can get data from the database in Excel directly with the same connection information and credential used in desktop, see: Import Data from Database using Native Database Query (Power Query).
Best Regards,
Qiuyun Yu
3 Replies
maybe I have found the solution (I answer to myself..), in query editor there is the option'copy entire table' that works...
Argh..... This option is limited to 1000 rows, the other are not copied !!!!
Hi perpor,
It's the known issue that the Copy Table function doesn't work in latest Power BI desktop version, you can see this thread.
When you use Copy Entire Table in Query Editor, it will copy data which are loaded in the table, it means you need to scroll down to load all table data, then use this feature to copy and paste whole table.
Also you can try to use table visual to show data from that table, then use Export Data feature.
As the table comes from the database, you can get data from the database in Excel directly with the same connection information and credential used in desktop, see: Import Data from Database using Native Database Query (Power Query).
Best Regards,
Qiuyun Yu