No hierarchies when connected to SSAS Tabular

There are currently several features that are only available in Excel with respect to visualizations and Excel will always be a first grade citizen when it comes to Microsoft BI, so I would not be ruling it out of equation completely.

There will be some frustration for a short while with having features disparity between different tools in the stack and this frustration is well justified. However, Power BI is in Preview right now (even if it’s just for a few more days) and even after that, we’ll have 60 days of free trial for Pro. So essentially we are getting a lot of value without having to pay much for it. If the product is still missing some key features for you, you should probably just wait until it becomes more mature. However, I suspect that for a great number of people (and I happen to be one of them), the product has a ton of very useful features today which more than justifies having to deal with some frustration for a short while longer.