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


Pre-requisites

 


Connecting from Power BI to OBIEE Reports


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.




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.