The data import wizard requires data to be cleaned and transformed prior to upload. This necessitates an off-platform process that is laborious and has a high change of introducing errors, resulting in frustration.

The Power Query Editor available in Power BI Desktop allows an intuitive and full-featured data cleansing and transformation process. This should be available as part of the Dynamics 365 data import wizard to allow users to optionally work with their data prior to mapping it to the correct table in Dynamics 365.