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

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?

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

      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.

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

        Well this is very frustrating. Before the hierarchies were shown as attributes so we can still use them but now they are completely gone which made it impossible for us to use the tool. It is same with the drill down reports which are not working with new report canvas. We were very excited for GA but not anymore:(