Forum Discussion
Solved
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 pas...
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
