Remove the limitation: "Power BI (web service) only supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type." Thousands (...
This one is now two years old and should be an easy fix. Please MS have a look at this.
