Forum Discussion
Solved
How to export entire table from Power Query
Hi guys, Like the subject, there is a menu for Copy Entire Table when we right click, but I believe this is still for 1000 only, am I right ? Thanks
admin_xlsior
Yes, it only gives 1000 rows. If you need to export your data for the whole table, you use DAX Studio to do it. Please follow the steps as described below.
https://www.youtube.com/watch?v=WaUCYUHLHdw
admin_xlsior
Yes, it only gives 1000 rows. If you need to export your data for the whole table, you use DAX Studio to do it. Please follow the steps as described below.
https://www.youtube.com/watch?v=WaUCYUHLHdw