How do i copy an entire dataset and paste it in Excel?

[ElioAngarita]

I have an entire dataset as the result of a query that i made in POWER BI, when i use the option of "copy table" it only gives me 1000 rows, but i do have 26k.

I've read online something about creating an INDEX column in my query, then a card and then setting it's MAX value.

I have both, but when i export is simply gives me:

Max of Index

27000

That's it, could you please help me?

[Anonymous]

Hi @ElioAngarita ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @ElioAngarita ,

According to your description, the data exported to Excel seems to be less than the data in Power BI Desktop, right?

Based on my test, it may caused by some filters have been applied like this:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.