...
PowerBI analyzes the first two hundred rows of your file to determine which settings should be used for import. In the event that you import fields with line breaks, like description fields, then PowerBI may accidentally split on those breaks and your imported data won't make sense. This occurs when the first two hundred rows are don't have line breaks. Excel then applies the wrong line-break settings.
...