Solved: How to export entire table from Power Query

admin_xlsior · ‎12-09-2021

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

Fowmy · ‎12-10-2021

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎12-10-2021

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up