The following is a general tutorial for connecting from Power BI to OBIEE using Direct Query with BI Connector Desktop Edition.
- Follow the Step-by-Step Installation Guide for BI Connector Desktop Edition for Microsoft PowerBI to install and configure BI Connector in your PC
- If you are using Microsoft Power BI Desktop June 2017 update or later, please refer to the following article to enable BI Connector in the Power BI Desktop.
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 box 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 and connect to the required database.
Step 6: On successful connection, list of Subject Areas will be displayed. Select a Subject Area from the list.
Step 7: select one or more tables from the list and click on load.
Note: BI Connector doesn't support bidirectional cross-filtering for DirectQuery. For more details, refer this article.
Step 1: Click on Mange Relationship and Manage relationship dialog pops up. Select New in the Manage relationship dialog as shown below.
Step 2: Select the Fact table from the drop down list as shown.
Step 3: Again select any dimension table from the drop down list as shown and relate tables to one another.
Step 4: Select the column GZID on both tables and a cardinality and Click Ok button.
Note: GZID is a BI connector virtual column that is used to ensure that PowerBI uses OBIEE joins for the direct query.
Step 1: Drag and drop the columns from the fact and dimension tables. Now you have created your first Power BI Visualization for OBIEE data. Congratulations!