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 ...

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