Chris Webb diagnoses a nasty-looking error:
When you’re using Excel workbooks as a data source in Power Query in either Excel or Power BI you may encounter the following error when trying to connect:
DataFormat.Error: File contains corrupted data.
Read on for information about three possible causes.