{"id":2833,"date":"2020-12-22T14:01:42","date_gmt":"2020-12-22T14:01:42","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2833"},"modified":"2021-05-14T11:34:17","modified_gmt":"2021-05-14T11:34:17","slug":"connect-power-bi-obiee-oac-oas-when-to-choose-import-direct-query-modes","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/connect-power-bi-obiee-oac-oas-when-to-choose-import-direct-query-modes\/","title":{"rendered":"How to Choose Between Import and Direct Query Modes When Connecting Power BI to OBIEE?"},"content":{"rendered":"
When you connect Power BI to Oracle BI (OBIEE\/OAC\/OAS) via BI Connector, you might wonder which connectivity mode works better – Import or Direct Query?<\/p>\n
In this blog post, we\u2019ll discuss how to choose between Import and Direct Query modes. Choosing between both these modes depends heavily on OBIEE\u2019s query execution time.<\/p>\n
Let\u2019s dive into the details!<\/p>\n
The Import mode is the recommended data connectivity mode for slow OBIEE queries.<\/p>\n
The OBIEE query execution time increases with increase in the queried dataset. The lesser the number of columns or rows in the queried Subject Area or Report, the faster the query execution.<\/p>\n
You can reduce the data by applying filters across your dimension tables for improving query performance.<\/p>\n
However, if the data is still large, the Import mode works best. You can still experience a better query performance with Offline Analysis.<\/p>\n
You can use the Direct Query mode when your OBIEE queries get executed faster.<\/p>\n
If you prefer to minimize the data loaded into Power BI, you must go for the Direct Query mode, as this mode enables you to avoid saving the dataset locally in Power BI.<\/p>\n
In Direct Query mode too, you can apply filters in the reporting canvas and narrow down to the right set of data while improving your OBIEE’s query performance.<\/p>\n
In some cases, you might blend OBIEE data with data from other data sources.<\/p>\n
In these scenarios, if you use Import for OBIEE and Direct Query for other data sources (or vice-versa), it is important to ensure the composite model works for your specific use case!<\/p>\n
You\u2019re also welcome to watch the below webinar recording on the topic, 9 best practices for connecting Power BI to OBIEE and OAC<\/b><\/a>, and simplify your Oracle BI data visualization with Power BI!<\/p>\n