When using the Web.Contents function to call a web service in Power Query in either Power BI or Excel you may encounter the following error:
DataFormat.Error: Block length does not match with its complement.
Click through to see what the problem is as well as what you can do to resolve it.