HI In the new report canvas I do not see SSAS hierarchies anymore.We have a date dimension having calendar year, month, date hierarchy with all the other attributes hidden. In Power BI it only shows the name of the date dimension nothing under it. Will it be available in GA? RegardsHarris

Well this kind of throws a wrench into things. I{ve been pushing in my company to use a BI Service and Power BI was the main contender. Sisense was the other one because of general polish and the drill down mode and Power BI having he Q&A kept it alive. Then I learned that using hierarchies you could basically do Drill Down and it was a no brainer that Power BI was the way to go (Taking into account that this worked 10 days ago). Now last week the Drill Down feature just dissappeared, I contacted support and they told me it was down for a few days for the GA release so all was good. Now it seems it's not coming for a while now. Now I have to go into the office tomorrow and explain how the Drill Down functionality is simply gone from Power BI which will not go well. I hope you guys reintroduce Hierarchies and Drill Down (which I'm sure you guys are working on integrating it into the new canvas) pretty soon so that my bosses can take another look at Power BI

Well the situation is same at our end. We are in phase of BI tool selection and our management had some concerns that Power BI is not a mature product right now and these type of things actually add fuel to fire. I agree with most of the feedback that the old hierarchies and drill down was not very intuitive but there is big difference between non intuitive and not available. Microsoft made us to re-think our plans.

Unfortunately I am in the same place with my company. It's now been a month since we lost drill-downs (despite having it available before and during the preview). I've been pushing Power BI to my leaders for a while but unfortunately this has now caused them to change their mind. They have simply lost trust in the fact these sorts of changes can be done with no communication or back up plan. Now I need to go and learn QlikView (which i'm not a huge fan of).

I too am at a loss to understand how such a fundamental thing like hierarchies wasn't included day one.

That is not the point...I want to use what I previously could do yesterday. I have wasted a whole morning on things that should have worked. I want to use direct connections with live data to a web based tool...using Excel is going backwards. If Excel is the answer, then why bother with this at all?

No hierarchies when connected to SSAS Tabular

15 Replies

danwilkins
New Member
11 years ago
Hi,

MS - Any update on likely timescales for inclusion of hierarchy and drill-down support? I'm keen deploying this but these are big drawbacks at the moment.

Thanks,

Dan
- SnoJa10
  Advocate IV
  11 years ago
  Unfortunately I am in the same place with my company.
  
  It's now been a month since we lost drill-downs (despite having it available before and during the preview). I've been pushing Power BI to my leaders for a while but unfortunately this has now caused them to change their mind. They have simply lost trust in the fact these sorts of changes can be done with no communication or back up plan.
  
  Now I need to go and learn QlikView (which i'm not a huge fan of).
  - Anonymous
    Not applicable
    10 years ago
    Is there any update on this? I just hit this roadblock in my POC, and am a little alarmed that this has not been discussed in over a month.
andre
Memorable Member
11 years ago
Whatever has been released thus far is most likely what will be available at GA plus the Power BI Desktop. So no hierarchies in the short term.
- CyrusOC
  Advocate I
  11 years ago
  I too am at a loss to understand how such a fundamental thing like hierarchies wasn't included day one.
  - andre
    Memorable Member
    11 years ago
    Well, my guess is that the development team had to make some tradeoffs in order to meet the GA date and it was one of them. I am confident that with the focus that Microsoft has on making Power BI the leading BI tool, we will see most of our gripes addressed relatively soon.

Forum Discussion

No hierarchies when connected to SSAS Tabular

15 Replies

Related content

Date hierarchy

SSAS Tabular Date Hierarchies not working with Live Connection

Date Hierarchy

Ragged Hierarchy?

Error connecting to database in Tabular Editor