Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.