This post explains how to fix ‘ DataFormat.Error: We couldn’t convert to Number ‘. Working with data in Power Query, whether in Excel or Power BI, can streamline analysis and reporting.

If you get the Download did not complete error message when using Power Query in Microsoft Excel, use these fixes.