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 ...
CyrusOC's avatar
CyrusOC
Icon for Advocate I rankAdvocate 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's avatar
andre
Icon for Memorable Member rankMemorable 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.

 

  • CyrusOC's avatar
    CyrusOC
    Icon for Advocate I rankAdvocate I
    11 years ago

    Not a good tradeoff. The current web report build seems to want to summarize my date column for year.  If I had my hierarchies, it would be really simple.   This is not going well at the moment, I cannot build any useful reports in the web browser.

    • andre's avatar
      andre
      Icon for Memorable Member rankMemorable Member
      11 years ago

      You can still use Excel to build your visuals and publish them to PowerBI.com  if you need any features that are still not present in the Service.  Hopefully, only for a short while...

      • CyrusOC's avatar
        CyrusOC
        Icon for Advocate I rankAdvocate I
        11 years ago

        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?