Forum Discussion

HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
11 years ago

No hierarchies when connected to SSAS Tabular

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 ...
WillT's avatar
WillT
Icon for Community Admin rankCommunity Admin
11 years ago
Hi everyone. Andre's right - we had a lot of features that we wanted to deliver and this didn't quite make it. We are working on it right now! It's also tied into the experience for navigating up and down through that hierarchy and we've had lots of feedback from users that the old mechanism for this wasn't intuitive - so we're spending some time redesigning that. It might mean that we hold back from support for basic hierarchies for a month or so but you won't have to wait long! In the meantime - we've seen most users hide the underlying fields that they use in their hierarchies, if that's the case for you then you can unhide them in the SSAS model and use them in your reports. You won't get the same folder-like structure but you'll still be able to get to the fields. Thanks for trying out Power BI!
HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
11 years ago

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.