Connect Power BI Datamart to OBIEE Reports using ODBC - Step-by-Step User Guide

Modified on Wed, 9 Oct at 1:50 AM

Please refer to the following articles before creating Datamarts using OBIEE Reports:

How to manage Reports list on BI Connector? 

How to connect to Datamart using BI Connector?

Connect to the Database

Click on the Database name to connect to the required database.



Select the report

  • 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.


  • Click Load.

  • After successfully loaded, add any changes if required and Close & Apply in Power query editor.



Now self created Datamarts are ready to be used in Power BI Service.