Excel export limit: does it not warns if you are downloading more than 150k rows?

[MaxItaly]

Hello everyone,

I'd like to have a confirmation about this: when i try to export in Excel something and it has more than 150K rows (I am a pro user), shouldn't it warn me that I'm downloading only a fraction of the total?
Or am I missing something?
If the final user is not warned about that, he may be analyzing some incorrect data.

[v-piga-msft · Accepted solution]

Hi @MaxItaly,

---

I'd like to have a confirmation about this: when i try to export in Excel something and it has more than 150K rows (I am a pro user), shouldn't it warn me that I'm downloading only a fraction of the total?
Or am I missing something?
If the final user is not warned about that, he may be analyzing some incorrect data.

---

Based on the document, the maximum number of rows that can be exported to .xlsx is 150,000.

If your download more than 150k rows you may get a limit warning.

For more limitations of Export data, you could refer to this official document.

In addition, you could refer to this similar thread.

Best Regards,

Cherry

[MaxItaly]

Hi, thanks for the info, but what I really wanted to have a confirmation why it does not warn me if I'm trying to download more than 150K rows.

It really should have to warn me.

I have already read those links, I'll just guess I can do nothing about it.

Thanks