Following is a general tutorial for connecting from Power BI to OBIEE Reports with Direct Query using BI Connector Desktop Edition
Launch Power BI Desktop. Select 'Get Data' option.
In the Get Data dialog, scroll down and select 'BI Connector' and click connect.
- 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.
Click on the Database name to connect to the required database.
- 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.
Drag and drop or select one or more fields to the join area.
Choose the desired visualization and you have now successfully created your first Power BI Visualization for OBIEE reports data.