Exporting power bi table back to power query or excel

[monojchakrab]

Hey good samaritans,

I have built my query tables in power BI, but I now need the final query table back in excel.

I have tried using dax studio to export the data - but while it exports it alright, the date column is returning blank somehow .

I have also tried using Power BI's own "copy entire table", but that is tansferring only the 1st 1000 rows.

Is there a fix thru' either of the routes?

Thanks

[Ahmedx · Accepted solution]

see this

https://community.powerbi.com/t5/Desktop/How-to-export-grid-or-matrix-with-15-20-columns-and-more-th...