Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi I got this warning;
"The data in the preview had been truncated due to size limits". I am wondering whether what the maximunm size of an excel file to be open up on Powr BI. I tryed with 1.8 MB excel file and got the above warning. Any improvements for this issue please.
Thank you
Dash
Solved! Go to Solution.
Preview is just how your data looks like and it takes around 1000 rows for column profiling and sampling of your data. It will always pull full data once you click "Close and Load"
There are bigger files that are opened in Power BI and their data successfully loaded in the model.
Proud to be a Super User!
Thanks a lot.
Preview is just how your data looks like and it takes around 1000 rows for column profiling and sampling of your data. It will always pull full data once you click "Close and Load"
There are bigger files that are opened in Power BI and their data successfully loaded in the model.
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |