How to connect Power BI with OLAP Cubes?

Overview

When using Power BI Desktop, it is possible to develop reports against your Jet Analytics OLAP Cubes. This article outlines the steps required to connect and form power bi OLAP connection with various settings represent.

This article assumes that you have the Power BI Desktop application installed. If this is incorrect, please visit the following link to download and install the Power BI application before moving further: Download Here.


Process to connect Power BI with OLAP cubes

  1. First, open Power BI Desktop. If presented with an opening screen like shown below, please close the window to proceed with this outline.
Power BI with OLAP cubes

2. Upon closing the opening screen (if applicable), you will see a blank Power BI report. To connect to your OLAP Cubes, click on the Get Data button in your menu bar. When the Get Data window opens, locate and click the SQL Server Analysis Services Database option, and then click Connect.

SQL Server

3. On the next screen, you will need to input the server name for the machine that your OLAP Cubes reside on.  If known, you can also include your OLAP database name (optional).Select the second radio button option that reads Select items and get data from Multidimensional or Tabular model. Click OK to continue.

SQL Server

4. On the next screen, you will be presented with a selection window from which you can select all of the various Measures and Dimensions that you want to use within the report (you only need to select the Measures and Dimensions that you want to use).When finished selecting your fields, click Load to continue.

Power BI with OLAP cubes

5. At this point you have connected your Jet Analytics OLAP Cube in Power BI. You will find the fields that you selected available for use on the right-hand side of the application.

Power BI with Olap

Interact Live
with Dashboards

Increase efficiency and deliver success now with Microsoft Power BI. Enjoy a 20% discount on all Power BI services.

Interact Live
with Dashboards

Increase efficiency and deliver success now with Microsoft Power BI. Enjoy a 20% discount on all Power BI services.

Need to learn more about advanced Power BI, opt for our training programs for better analysis today.

If You Need Any Help, Contact us Now!

Scroll to Top