Quick Q&A on BI Connector!

What is the difference between Import and DirectQuery connection to OBIEE? What are the limitations, if any, of each?

When choosing to import data from OBIEE, Power BI imports the data into its in-memory cache. You can create visualizations from the imported data. To see the current data in OBIEE, you should refresh.

When you use DirectQuery, Power BI Desktop does not import or copy the OBIEE data. You can view the list of columns in Fact and Dimension tables. As you create visualizations by choosing the columns, data is queried from OBIEE via BI Connector. You always see the current data in OBIEE. DirectQuery works well with large multi-dimensional data sources such as OBIEE.

To learn more about the difference between Import and DirectQuery connections to OBIEE, please refer to our blog article on this topic.

Where is the BI Connector Server Edition installed?

BI Connector Server Edition is installed on the same machine in which the Power BI On-premise Gateway is installed.

Is DirectQuery supported via Power BI On-Premise Gateway when connecting to an OBIEE data source using BI Connector?

Yes, BI Connector supports DirectQuery connections to OBIEE data sources via On-Premise Gateway.

Have Questions?

You’re just a click away from the BI Connector team.

Just Getting Started?

Jump-start your BI Connector journey with free technical help from a BI Connector expert.