Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

SQL Server Analysis Services Cubes

Enable connectivity to on-prem (or IaaS) SSAS Cubes / multidimensional!
Status: Completed
Comments
malcolm_wanstal
New Member
Any chance on some communication around ETAs on this functionality? I'm sure many others have platform decisions to make as well that hinge on the availability of this feature.
Daniel_Djuracic
New Member
Blog advises that PowerBI mobile is "Enterprise Ready" yet there is still no OLAP cube support. Please advise an ETA for this feature.
AlejoSQL
Advocate I
This feature has been included on today´s release (November Update) in the preview mode. Check it out here! http://blogs.msdn.com/b/powerbi/archive/2015/11/20/announcing-the-power-bi-desktop-november-update.aspx?wt.mc_id=WW_CE_BI_OO_SCL_TW
pbiideas1
New Member
Works great, in preview mode. Is it possible or planned to connect to more than one cube per report? Is it possible to change the number format of values in a matrix table?
mkasak
New Member
I've connected to SSAS multidimentional and i've seen my cubes, but after i have error Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services.
chrisblank
New Member
I have tried connecting following the instructions provided on the updates page, and I get the error "Currently, Power BI only supports connecting to Analysis Services Tabular Models.
fbcideas_migusr
New Member
Some of the dimensions are not available when i tried to connect with the SSAS OLAP, just wondering why is it so?
matteo_fossati
New Member
Hi, I've connected to SSAS multidimentional (SQL2014) and i've seen my cubes, but after i have error Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services. I have flagged the preview mode in Power BI desktop
patoduck1
New Member
What about for those users outside the network? I need to "Browse live" a tabular model, but I'm not connected to the network, can you guys do something similar to OLAP pump via HTTPS?
arehman1
New Member
Hi, Is this feature available on Power BI cloud service yet? If not then any tentative date for enabling this on the cloud?