I'm converted as a fan of PowerBI rather than Embedded SSRS for reporting. However I ran into an interesting user fear today, so I thought i would share it here.
The user has a report that is run every Friday and printed out in the legacy ERP system which is now being replaced with D365. We are talking about around 100 pages. While my suggestion was to do this report as a PowerBI report using Directquery - the users will have computers and don't need the printout - the response was "We need all our reports to be printouts (ie SSRS) because if the system is down we can keep working. We print everything we need for the next week for operations, even if we can use a screen".
I guess my question could be a poll - with modern cloud based computing, is this a realistic fear any more? Do people really see D365 crashing or having unexpected downtime in production like the old on-prem solutions?
I'm leaning towards this being an unfounded fear and is about change management and user expectation...maybe we can save some trees. Does anyone have any thoughts?