In one of my previous posts I explained how to use Power BI on top of your SSAS Multidimensional using Data Import Scenario. You can also find definitive explanation about “Managing Analysis Services Multidimensional Model” here. In this post I show you how to connect live your SSAS Multidimensional model with Power BI. “Connect Live SSAS Multidimensional” means making a Direct Connection from Power BI Desktop to your SSAS Multidimensional instance.
As it is a direct connection you’ll be able to see/use the following SSAS Multidimensional objects:
- Cubes
- Perspectives
- Measure Groups
- Measures
- Dimensions
- Dimension Attributes
- Hierarchies including Parent Child
In this post you’ll learn:
- How to connect live from Power BI Desktop to SSAS Multidimensional
- Creating reports using SSAS objects like hierarchies
- Publishing your reports from Power BI Desktop to Power BI Service
Requirements
To be able to successfully create and publish your reports using Power BI Desktop on top of SSAS Multidimensional you will require:
- The latest version of Power BI Desktop (Current version is 2.31.4280.361 64-bit (January 2016))
- On-premises Data Gateway
- Managing SSAS Multidimensional Data Source from Power BI Service
- Power BI Service Pro Account
- SQL Server 2012 Analysis Services SP1 CU4 or later (Enterprise or Business Intelligence editions only)
Continue reading “Connect Live Power BI to SSAS Multidimensional”