I'm curious why my posts keep getting removed with the message "This was removed by the editor as SPAM". I thought I hnad legitimate contributions.
Respectfully, the chasm between Power BI and SSRS is greater than the article portrays. It's an important distinction because managers (like mine) have made business decisions based on this.
Essentially, Power BI is for interactive analytic dashboards, operative word "interactive". They can't really be printed; the PDF is really just a single page export to a PDF file. The Excel (CSV file) Export is great if you didn't need the underlying detail. But the interactive nature of it is massively powerful! It's worth the effort; it's just not the tool for printing your Customer Master listing, or to print invoices or factory labels, etc.
With the advent of "Power BI Paginated Reports" (aka: a slightly altered SSRS, wrapped inside the Power BI Service), the lines have blurred, but a project to "rewrite all SSRS to Power BI" becomes one of directly converting most of them into to Paginated Reports platform, and maybe bundling a few into new Power BI Visual Dashboards where it makes sense, possibly as a front-end where they can run the Paginated Report for greater detail or printable output.
However, the ROI for this effort isn't there for most of the reports because they're exactly the same as before, possibly even new issues (like security, menuing, data pipelines, licensing costs, or even new bugs) introduced. Better to use Power BI for its intended purpose. It's Excel's Pivot Tables on steroids.
I hope THIS comment isn't rejected as spam (please). I'm not a spammer. It's the first thread I've decided to contribute to after lurking and reading SQL articles for years. I love the content, but scratching my head at being called a "spammer" just for offering my 2 cents.