The following is a general tutorial for connecting from Power BI to OBIEE using Direct Query with BI Connector Desktop Edition.
- 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)
Launch Power BI Desktop. 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 Direct Query 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 load.
Configure Relationships between tables
Note: BI Connector doesn't support bidirectional cross-filtering for DirectQuery. For more details, refer this article.
Click on Mange Relationship. Select 'New...' in the Manage relationship dialog as shown below.
Select the Fact table from the drop down list as shown.
Select any dimension table from the drop down list as shown and related table to one another.
Select the column GZID on both tables, and select the cardinality to Many to one 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.
Please make sure to select the fact table on the top and the dimension table on the bottom while creating the relationship.
Drag and drop the columns from the fact and dimension tables. Now you have created your first Power BI Visualization for OBIEE data. Congratulations!