SQL Server Analysis Services Cubes
Enable connectivity to on-prem (or IaaS) SSAS Cubes / multidimensional!
SSAS cubes are the backbone for a proper, powerful and effective BI stack. SSAS is a wonderful tool, it's fundamental that Power BI fully and seamlessly connects to it.
We are looking into supporting MOLAP in Power BI. Continue voting on this so that it helps the product team prioritize the features across all the other feature requests.
Many MOLAP on field, this connector will not be a best have but really necessary.
Dhananjay Choubey commented
We are using OLAP (multidimensional) for one of our client for more than 6 yrs now. We are looking to utilize this new PowerBI, but lack of support for multidimensional OLAP is a big road block for us. Any update on the timeline is highly appreciated.
Craig Myers commented
Please update the AS connector for access to on-prem multidimensional.
Greg Hyzak commented
Another vote for native connectivity to SSAS OLAP cubes. You guys really are underestimating the uptick in usage of Power BI if you provided this support. SSAS OLAP cubes continue to be the "hidden gem" in the Microsoft BI stack.
Victoria Phillips commented
Agree, not supporting Multidimensional cubes is blocking us in offering the new capabilities within our Finance team.
Pooja Sund commented
Hello Power BI team, we have "Multidimensional OLAP" cubes for last 5 years. We are really looking to utilize the new Power BI for our finance business but the present limitation of Power BI ( not supporting Multidimensional cubes ) is a roadblock in offering the new capabilities. Would be great if you can prioritize on this as we have over 400 users across the world who would be possibly using the new Power BI connection to multidimensional once that's enabled. Thanks!
Mick Letofsky commented
We are a looking to utilize PowerBI to get more out of our on premise TFS environment. We have customized the environment and application to the point where we aren't a candidate for VS Online at this point which is why we need this functionality in PowerBI.
Mitsu Madhani commented
We would really like to move ahead with this and one of the key constraints that we have currently is the support for Multi Dimensional Cube . Any Ball park time line on this would really help us strategies our BI product strategy which is based on MSBI stack .
ray malone commented
Any update on timeline?
Vinay B commented
Is there any plan to bring component similar to Microsoft Office Web Components(Pivot Grid) which uses as Microsoft OLAP Data Cubes. https://technet.microsoft.com/en-us/library/cc197469(v=office.12).aspx
As Microsoft Office web component are stoping there support going forward from 2016, so we are looking an alternate(Similar) component to display the Data Cube data.
Rui Quintino commented
Hi, just reinforcing the urgency of this. Customers roadmap on hold waiting for this specific feature. (note: on hold regarding Microsoft platform,... pressure is high these days, they won't wait forever... :( )
My concern on not having a firm timeline, is that it will never happen, or way too late for most customers. (excel powerview multidimensional comes to mind)
Also important to know, expected limitations as I am sure they will exist, ex: will it work with QA? what won't work with cubes?
Aleksandr Lazutkin commented
For us it is really important. Otherwise, it makes no sense, since the update dozens or hundreds millions rows from the fact table in powerbi not real without partitioning
Kirk Townsley commented
I also would like to see the ability to connect to SSAS cubes (OLAP) on-premise as an option escalated. We have a new Sharepoint site we are ready to deploy and also a new Tablet solution rolling out in 2015 and this could be the killer app for both and a great addition to our tools/investment in SQL that we have made in the past.
Sandeep Reddy commented
Please escalate this. We are planning to move forward with PowerBI on large scale but have a huge investment in Multidimensional cubes for a long time. Without the support we cannot move forward
Wesley Backelant commented
Are we planning to also support ROLAP in this scenario?
Hi Lukasz - when can we expect this functionality? ball-park?
Making sure this is OLAP and not "just" TABULAR
Trond Brande commented
Enable SSAS cubes to be consumed and hopefully respect security settings in the cube as well