Forum Discussion

Darsh's avatar
Darsh
New Member
4 years ago
Solved

Size limits

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 e...
  • FarhanAhmed's avatar
    4 years ago

    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.