Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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!
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 50 | |
| 34 | |
| 32 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 64 | |
| 64 | |
| 41 | |
| 27 | |
| 24 |