When you're transforming data in Power BI or Excel using Power Query, you're bound to run into errors —mismatched data types, division by...