The following is a general tutorial for connecting from Power BI to OBIEE using BI Connector Import with BI Connector Desktop Edition.
Launch Power BI Desktop and 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.
- Click Ok button.
On successful connection,Click on the Database name and connect to the required database.
list of Subject Areas will be displayed. Select a Subject Area from the list.
Select one or more tables from the list and click on Edit button.
Click on 'Merge Queries'. Select table from the drop down list that needs to be merged.
Select the column GZID on both tables and select the 'Join Kind' to Left Outer and click Ok button.
Select the required columns from the merged table for visualization.
Click 'Close and Apply' option to apply changes.
Drag and drop the columns from the fact and dimension tables. Now you have created your first Power BI Visualization for OBIEE data. Congratulations!