Following is a general tutorial for connecting from Power BI to OBIEE Reports with Direct Query using BI Connector Desktop Edition
Pre-requisites
- Microsoft Power BI Desktop December 2018 update or the latest version.
- BI Connector Desktop Edition for Microsoft PowerBI. (Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI)
Connecting from Power BI to OBIEE Reports
Launch PowerBI Desktop
Launch Power BI Desktop. Select 'Get Data' option.
Select BI Connector
In the Get Data dialog, scroll down and select 'BI Connector' and click connect.
Enter DSN Information
- 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.
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.
Select the fields to visualize
Drag and drop or select one or more fields to the join area.
Choose the different visualization
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 [email protected] or file a ticket at support portal.