Connect Power BI Desktop to OBIEE Reports using Direct Query - Step-by-Step User Guide

Modified on Wed, 06 Feb 2019 at 10:33 PM

Following is a general tutorial for connecting from Power BI to OBIEE Reports with Direct Query using BI Connector Desktop Edition


Pre-requisites

  1. Microsoft Power BI Desktop December 2018 update or the latest version.
  2. BI Connector Desktop Edition for Microsoft PowerBI. (Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI)

Connecting from Power BI to OBIEE Reports


Launch PowerBI Desktop

Launch Power BI Desktop. Select 'Get Data' option.



Select BI Connector 

In the Get Data dialog, scroll down and select 'BI Connector' and click connect.



Enter DSN Information

  • In the BI Connector dialog box , Select Direct Query radio button.
  • Enter the DSN name that you configured after installing BI Connector. Advanced Options are not necessary.
  • Click Ok button.



Connect to the Database

Click on the Database name to connect to the required database.



Select the report

  • On Successful Connection, a Report will be displayed if you provide a path of a particular report or a list of Reports will be displayed if you provide a path of the folder. You can Select the Report from the list also.
  • The list of Reports will be displayed just like a Table. Select a report and click on load.



Select the fields to visualize

Drag and drop or select one or more fields to the join area.



Choose the different visualization

Choose the desired visualization and you have now successfully created your first Power BI Visualization for OBIEE reports data.



If you have any questions or issues creating a report, we are just a click away.  Contact us at support@biconnector.com or file a ticket at support portal.