You might reach out to @nickcald and see if you can get a more definitive answer on exactly what the functionality will be. Not sure if he will respond, but worth a shot.
Proud to be a Datanaut!
The business requirement is that we can't lose any existing functionality and thats how its currently delivered and the recipients actually really like that functionality. Regardless of whether it makes sense, its the way it is.
Those are the phrase we hate the most whenever we go through Change Management or as a Project Manager and Director of IT, "That's how we've always done it".
There were some who swears on Excel, in Dynamics, we use Jet Reports since it lives in Excel and have similar functionalities as PowerBI on their latest release. It does have the ability to connect to SQL even if you're not using Dynamics ERP.