{"id":2328,"date":"2020-08-18T13:36:25","date_gmt":"2020-08-18T13:36:25","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2328"},"modified":"2023-06-02T08:44:52","modified_gmt":"2023-06-02T08:44:52","slug":"connecting-power-bi-to-obiee-via-bi-connector","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/connecting-power-bi-to-obiee-via-bi-connector\/","title":{"rendered":"Connecting Power BI to OBIEE: How BI Connector Bridges the Gap?"},"content":{"rendered":"

Organizations using OBIEE are adopting the bimodal analytics approach to effectively complement the data visualization limitations in OBIEE with self-service analytics tools like Power BI.<\/p>\n

Some organizations have even switched to Oracle Analytics Cloud (OAC) but still want to connect Power BI to OAC, as a significant number of users (who are already well-acquainted with Power BI) prefer to do so.<\/p>\n

In this blog post, we\u2019ll see how to connect Power BI to OBIEE using BI Connector based on your unique needs. Then we’ll wrap up with the pros and cons of connecting Power BI to OBIEE using BI Connector.<\/p>\n

First, let\u2019s see what is BI Connector<\/a>.<\/p>\n

What\u2019s BI Connector<\/h2>\n

BI Connector is a purpose-built connector for integrating OBIEE data sources with modern visualization tools like Power BI, Tableau, and Qlik. BI Connector helps to effectively complement the data visualization limitations of OBIEE with advanced visualization tools in a bimodal approach.<\/p>\n

From a technical standpoint, BI Connector is an ODBC driver and connects to both OBIEE Subject Areas and Reports DSNs. When connecting to the Subject Areas, you can retain the table joins as well using BI Connector.<\/p>\n

BI Connector (Power BI certified) converts Power BI queries into OBIEE queries and fetches the underlying data from OBIEE into Power BI. BI Connector comes in 2 editions:<\/p>\n

    \n
  1. Desktop edition for Power BI Desktop<\/li>\n
  2. Server edition for Power BI Service<\/li>\n<\/ol>\n

    BI Connector works seamlessly in both Import and Direct Query modes. BI Connector also helps to smartly avoid OBIEE\/Power BI version compatibility issues as well.<\/p>\n

    In short, BI Connector meets all the 5 must-haves of a Power BI OBIEE Connector<\/b><\/a>.<\/p>\n

    Ok, now let’s go to the how-to part!<\/p>\n

    How to Connect Power BI to OBIEE using BI Connector<\/h2>\n

    In this section, you could be looking for different answers, based on each of the unique needs you have. Let’s see them one-by-one!<\/p>\n

    How to setup OBIEE Report (or Subject Area) DSNs using BI Connector<\/p>\n