Size limits

[Darsh]

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

[Darsh]

Thanks a lot.

[FarhanAhmed · Accepted 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.