Following is a general tutorial for connecting from Power BI to OBIEE Reports with Direct Query using BI Connector Desktop Edition
- Follow the Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI to install and configure BI Connector in your PC.
- If you are using Microsoft Power BI Desktop June 2017 update or later, please refer to the following article to enable BI Connector in the Power BI Desktop.
Step 1: Launch Power BI. Select Get Data option.
Alternately, You can select Get Data Option ,
Step 2: In the Get Data dialog, scroll down and select BI Connector.
Step 3: Click Connect and BI Connector dialog pops up.
Step 4: Next,
- Enter the DSN name that you configured after installing BI Connector. Advanced Options are not necessary.
- Select Direct Query radio button.
- Click Ok button.
Step 5: Click on the Database name to connect to the required database.
Step 6: 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. Select the Report from the list. Also
Step 7: The list of Reports will be displayed just like a Table. Select a report and click on load.
step 8:Drag and drop or select one or more fields to the join area.
Step 9: Choose the desired visualization and you have now successfully created your first Power BI Visualization for OBIEE reports data.