Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have now searched the web a few days to find any information about SQL Server requirements to enable live query from Power BI to an Analysis Services Multidimensional cube.
I know that you need atleast to be on a SQL Server 2012, but does this feature work with all versions of the SQL Server 2012? Standard, BI and Enterprise?
I hope someone can answer this.
Kind Regards,
Søren
Solved! Go to Solution.
@sdjensen It sounds like this is the page you are looking for. The below section found in the link states the requierements.
Limitations of SSAS Multidimensional Models in Power BI Desktop
There are certain limitations to using the preview version of SSAS MD:
Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services for the Power BI Desktop SSAS MD connector to work properly
Only Enterprise and Business Intelligence editions of SQL Server are supported for MD connectivity
Display Folder, Cell level Formatting, KPI Trends, and translation features are not supported in this preview build of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.
Starting in the December 2015 release of Power BI Desktop, users can consume hierarchies defined in the model, including the entire hierarchy or any levels (parent levels are added automatically). Support for removing intermediate levels and Slicer support is coming in upcoming releases. The workaround for this limitation is to use the page level or report level filtering of a hierarchy.
In addition, as mentioned earlier you cannot publish a report created with the preview version of SSAS MD to the Power BI Service.
It would work with any version of SQL Server 2012 that supported Tabular models.
I am not talking about the tabular model... I am talking about the Multidimensional model.
@sdjensen It sounds like this is the page you are looking for. The below section found in the link states the requierements.
Limitations of SSAS Multidimensional Models in Power BI Desktop
There are certain limitations to using the preview version of SSAS MD:
Servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services for the Power BI Desktop SSAS MD connector to work properly
Only Enterprise and Business Intelligence editions of SQL Server are supported for MD connectivity
Display Folder, Cell level Formatting, KPI Trends, and translation features are not supported in this preview build of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.
Starting in the December 2015 release of Power BI Desktop, users can consume hierarchies defined in the model, including the entire hierarchy or any levels (parent levels are added automatically). Support for removing intermediate levels and Slicer support is coming in upcoming releases. The workaround for this limitation is to use the page level or report level filtering of a hierarchy.
In addition, as mentioned earlier you cannot publish a report created with the preview version of SSAS MD to the Power BI Service.