Connecting Centage Cubes to Power BI Desktop

Centage Cubes are read-only, published views of your data that you can examine and analyze from different angles, like a Rubik’s cube. You can use a Cube to drill down to the smallest details or study the broadest overviews of your data.

Centage’s Analytics Maestro is a plug-in to Microsoft Excel you can use to examine Cubes. You can also use the Power BI Desktop App to review your Cubes. Using Power BI for Cubes enables you to set up your data in Centage and then use Power BI’s analytics tools to study and analyze it.

This document shows you, a Centage user, how to set up the Power BI Desktop App to examine Centage Cubes.

Step 1: Open the latest version of the Power BI Desktop App and select Get Data.

Step 2: On the Get Data page, select SQL Server Analysis Services Database and click Connect.

Step 3: Enter https://<<ANALYTICS MAESTRO HTTP SERVER NAME>>/OLAP/msmdpump.dll in the Server field and select the Import radio button. Click OK. Your Analytics Maestro Connection String can be found in Centage Settings.

Step 4: An Access SQL Server Analysis Services popup appears. Select the Basic tab and enter your Cloudmaestro username and password in the fields provided. Click Save.

Step 5: The Navigator page opens and displays the Cubes you can access.

Step 6: Select the Cube you want to analyze using Power BI and configure the data by:

• Selecting the Cube Dimensions you want to analyze.
• Selecting a Measure (a method for organizing your data in Power BI) from the Fact LM directory.

Step 7: Click one of the buttons below to send the data to the Power BI Desktop App:

• To send the Cube to the Power BI Desktop App as it is without making any changes, click Load.
• To send the Cube to the Power BI Desktop App with changes, click Transform Data.

Step 7: The Power BI Desktop App opens. To publish the Cube and examine it, click Publish.

Step 8: When the data is published successfully, a Publishing to Power BI popup appears with a Success! message. Select Open [name of the Cube] in Power BI.

Step 9: The Cube is now available in the Power BI Cloud. Select the name of the Cube to open it and use Power BI tools to analyze it.