We tried PowerBI - for us, it was good for dashboard creation, but our exec team didn't like the idea of one more tool to login to. The subscribe feature to send an embedded single tab in email is too limiting (and small) when you have a multi-page dashboard.
So, we are getting started with the Azure BYODB SQL Server. We are building out Crystal Reports and linked Excel documents for our bigger reports -- these can show up automatically in your inbox or run as you need them. You don't need a developer, just a business or financial analyst to create the report.
If you've found this thread useful, dive deeper into User Group community content by role