Sometimes, the data is in the field correctly, but it is not capitalized the way you want or there are blank spaces at the end of the field. This will happen more than you would expect. Power BI can handle these situations as well.
In a database, a single field will have a maximum allowable length. Occasionally, all data in those fields will be the maximum length, even when spaces are used to fill the empty spots. Imagine you have a Vendor ID field with a maximum allowable length of 16 characters, which is the case in Microsoft Dynamics GP. In some tables, Vendor ID ABC001, which is actually six characters, will fill the entire space so 10 blank spaces are at the end. Normally, these blank spaces are not an issue; although, it will take longer to extract the data because it has to pull each blank space as well. If it were just a matter of data extraction, we probably wouldn't even address this issue in this introduction...