To fix DataFormat.Error, We couldn't convert to Number, when working with data in Power Query, whether in Excel or Power BI use these solutions ...

Streamline Your Workflow with Power Query Power Query provides a robust and flexible approach to combining and transforming data from multiple Excel sheets into a single, structured dataset.

The error Something went wrong Code 0x0 0x0 error is usually seen on Windows Insider Builds. Here are some suggestions to help you.