@spencer13015, thank you for your post.
I have been tasked with getting to grips with PowerBI, it's new and partially available to us now. I have single-handedly developed a vast range of reports using SSRS for my firm over the last 6+ years, for various audiences - client to board - from most of our key systems (all on-prem SQL).
I've seen many, many breathlessly enthusiastic exponents rave about the simplicity and power of PowerBI, I was even quite enthusiastic myself, until I started try to use it.
My take so far has been, it's great if you are a very small firm, with enthusiastic "power users" of Excel, or a very large organisation with a lot of developer resources and money to spend on licensing.
If you are a medium sized enterprise with stretched IT resources, on-prem data and a user base with no ability, time or appetite to become "citizen developers", who are used to real-time data in reports then my first impression is that it is a very, very poor relation to SSRS reports with well-crafted SQL datasets, while at the same time being a significantly higher cost and complexity.
Every "simple, drag and drop, no-code" step so far has been thwarted by requiring a better licence. Don't get me started on the On-Prem Gateway.
I'm sure my down-ness has much to do with inexperience, but compared to being able to produce meaningful, powerful and useful reports from SSRS, within a day or two of finding out it even existed - self taught, and with little SQL experience (at the time) I am not impressed with it.
I am also sure that once our data moves off-prem the balance will swing the other way.
I am glad I am not alone in my healthy scepticism.
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?