Following is a general tutorial for connecting from Power BI to OBIEE Reports with BI Connector Import 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 Import 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 Power BI Visualization for OBIEE reports data.