How do I connect to a Data Cube via Power BI Desktop?


Connecting to a Data Cube on Power BI Desktop

  1. Open Power BI Desktop
  2. On the Home ribbon, select Get Data, then Analysis Services.
    A screenshot where the following selections are highlighted: "Get Data" button and "Analysis Services" selection.
    Selecting "Analysis Services" in Power BI
  3. Populate the SQL Server Analysis Services database window as follows and then click OK.
    Field/Button Description
    Server Enter cubes.uw.edu.
    Radio button Select Connect live.

     

  4. On the Windows tab of the Access SQL Server Analysis Services window, select Use my current credentials, and then click Connect.
  5. In the left pane of the Navigator window, expand the cube you want to select, select the model or view (if applicable), and then click OK.

You are now connected to the cube. You only need to perform these connection steps once per cube. To access this connection when opening a new workbook, select the Data tab, and then click Existing Connections.

For more information, refer to Connect to Analysis Services tabular data in Power BI Desktop.