We had made several attempts at incorporating BI visualizations into our analysis but Tableau was out of our reach and SAS BI was too complex for the majority of our users. For us then, Power BI was eyeopening because it connected to all of our data sources and within weeks we were using the drill-down functionality to do visual analysis that we weren't previously capable of.
There is complexity and we have a couple of developers who dedicated themselves to learning the specifics and intracacies of DAX code and whom regularly download the latest updates to say current but for most users it is pretty straight forward.
As other reviews have stated, it is not easily shareable. For our purposes, each analyst has their own copies of analytic dashboards and we have to make special versions with pre-loaded data if we need to present out.
Also, while it is very nice that they keep adding features, as our developers incorporate new functions, all users have to individually update their Desktpop BI. We're approaching 90 analysts so this is becoming cumbersome even if it only takes a couple of minutes.
For our purposes Power BI has been a great tool and an excellent introduction to BI in general but it does belong in the Self-Service category for now until it is more enterprise-friendly to compete with big boys.