Ability to create an Excel Workbook based on any area within Sage 200

I frequently have to create SQL Views via an ODBC link in Excel to get additional Excel based reports. Please provide a method to create our own reports and allow these to be linked to most if not all areas within Sage 200 including Project Accounting. Sage 200 BI hasnt been updated in a long time and competitor products have a better way of reporting in Excel accessing all areas of the ERP system. Microsoft update Power BI monthly and it would be nice to have something similar in Sage 200.