My current company sells telephony and call-center analytics for MS Teams using our software, and during pre-sales meeting, one of the staple questions is "So we can avoid Power BI entirely?" followed by a minor thanksgiving ceremony and presentation of credit card. I get a feeling it's not too dear to the hearts of its users.
What’s nice is that it’s better than Excel so if you want to replace Excel, PBI is great. But if you want a functional data viz that you’re not embarrassed to put on your web site, I’m not sure PBI works.
Most people just don’t to analyze data and hardly even know how to use Excel, so something like Power BI or Tableau looks like rocket science when really these tools should make you feel like you’re upgrading to power tools from basic hand tools.
PowerBI / Tableau is much more full-featured.
It takes a lot of trial and error and patience to finally grasp how Power BI handles calculations if you are used to the freedom of Excel.
That being said, once it clicks, it feels like you are a magician, and you can do really advanced analytics on giant tables, which is great.
We pull a bunch of data out of the guts of MS Project 2010 and do a lot of custom analysis on it. It took about two years to go from scratch to a set of reports that served everyone's needs that also required minimal maintenance.
Then we got purchased by a larger company, so now the work is in rolling out a similar set of reports for the sister companies, as well as rolling them up into corporate-wide reports. It's a lot of fun.
To put things in context, our small claim to fame is anyway getting some aggregate data about lost calls and attempts that is not possible to produce in Power BI directly[1]. So it's likely that they would buy or not buy it even if it was based on Power BI itself.