{"id":2582,"date":"2020-11-24T11:07:35","date_gmt":"2020-11-24T11:07:35","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2582"},"modified":"2021-05-14T11:34:17","modified_gmt":"2021-05-14T11:34:17","slug":"power-bi-obiee-connector-challenges-and-best-practices","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/","title":{"rendered":"The Challenges in Connecting Power BI to OBIEE and How to Overcome Them?"},"content":{"rendered":"

Many organizations using Oracle Business Intelligence Enterprise Edition (OBIEE)<\/a> complement its data visualization limitations with a self-service analytics tool such as Power BI.<\/p>\n

Connecting Power BI to OBIEE in an automated way is the best way to tackle OBIEE\u2019s limitations with Power BI successfully, as manual data export\/import via Excel is cumbersome.<\/p>\n

Challenges in connecting Power BI to OBIEE<\/h1>\n

When connecting Power BI to OBIEE, the first question to ask is if you\u2019re using the right Power BI OBIEE Connector<\/a>.<\/p>\n

The connector must meet the below criteria at the minimum:<\/p>\n

    \n
  1. Connect to both OBIEE Subject Areas and Reports<\/li>\n
  2. Retain OBIEE joins<\/li>\n
  3. Support both Import and Direct Query modes<\/li>\n
  4. Compatible with both Power BI Desktop and Server<\/li>\n
  5. Eliminate Power BI\/OBIEE version compatibility issues<\/li>\n<\/ol>\n

    You can learn in detail about each of these criteria in the blog post about the 5 things to consider when you choose a Power BI OBIEE Connector<\/b><\/a>.<\/p>\n

    Enjoy hassle-free visualization of OBIEE data in Power BI. Connect OBIEE\/OAC\/OAS and Power BI with the Power BI certified BI Connector<\/a>.<\/div>\n

    9 Best Practices for Connecting Power BI to OBIEE<\/h1>\n

    Once you choose the right connector, you\u2019re already more than halfway through! The remaining part is all about following the best practices for connecting Power BI to OBIEE.<\/p>\n

    The 9 best practices are both for the IT and end-user community. It hardly takes 30 minutes to learn the 9 best practices, and see them in action!<\/p>\n

    We, at BI Connector<\/a>, interacted with 100s of BI Connector users and curated these best practices for helping users to:<\/p>\n

      \n
    1. Get familiarized with OBIEE data and improve their data literacy<\/li>\n
    2. Troubleshoot connectivity issues in DIY mode<\/li>\n
    3. Optimize query performance by adjusting 4 simple parameters<\/li>\n
    4. Retain your OBIEE Subject Area joins in simple steps<\/li>\n
    5. Eliminate data mismatch issues and HTTP timeout errors<\/li>\n<\/ol>\n

      Curious to know the best practices? Well, here are they!<\/p>\n

      \"Best<\/a><\/p>\n

      Watch the tutorial covering the 9 best practices with demos, and experience hassle-free visualization of your OBIEE data with Power BI.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Many organizations using Oracle Business Intelligence Enterprise Edition (OBIEE) complement its data visualization limitations with a self-service analytics tool such as Power BI. Connecting Power BI to OBIEE in an automated way is the best way to tackle OBIEE\u2019s limitations with Power BI successfully, as manual data export\/import via Excel is cumbersome. Challenges in connecting […]<\/p>\n","protected":false},"author":19,"featured_media":2594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76],"tags":[90],"yoast_head":"\nPower BI OBIEE Connector challenges and best practices<\/title>\n<meta name=\"description\" content=\"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI OBIEE Connector challenges and best practices\" \/>\n<meta property=\"og:description\" content=\"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\" \/>\n<meta property=\"og:site_name\" content=\"BI connector Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/biconnector\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-24T11:07:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-14T11:34:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"BI Connector Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:site\" content=\"@bi_connector\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"BI Connector Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"The Challenges in Connecting Power BI to OBIEE and How to Overcome Them?\",\"datePublished\":\"2020-11-24T11:07:35+00:00\",\"dateModified\":\"2021-05-14T11:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\"},\"wordCount\":341,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png\",\"keywords\":[\"Power BI to OBIEE\"],\"articleSection\":[\"Solution Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\",\"name\":\"Power BI OBIEE Connector challenges and best practices\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png\",\"datePublished\":\"2020-11-24T11:07:35+00:00\",\"dateModified\":\"2021-05-14T11:34:17+00:00\",\"description\":\"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Challenges in Connecting Power BI to OBIEE and How to Overcome Them?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"name\":\"BI connector Blog\",\"description\":\"Blog on BI, Analytics, and Integration\",\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\",\"name\":\"BI Connector\",\"url\":\"https:\/\/www.biconnector.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg\",\"width\":1,\"height\":1,\"caption\":\"BI Connector\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/biconnector\",\"https:\/\/x.com\/bi_connector\",\"https:\/\/www.linkedin.com\/company\/bi-connector\",\"https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\",\"name\":\"BI Connector Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g\",\"caption\":\"BI Connector Team\"},\"sameAs\":[\"https:\/\/www.biconnector.com\"],\"url\":\"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI OBIEE Connector challenges and best practices","description":"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/","og_locale":"en_US","og_type":"article","og_title":"Power BI OBIEE Connector challenges and best practices","og_description":"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.","og_url":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2020-11-24T11:07:35+00:00","article_modified_time":"2021-05-14T11:34:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png","type":"image\/png"}],"author":"BI Connector Team","twitter_card":"summary_large_image","twitter_creator":"@bi_connector","twitter_site":"@bi_connector","twitter_misc":{"Written by":"BI Connector Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"The Challenges in Connecting Power BI to OBIEE and How to Overcome Them?","datePublished":"2020-11-24T11:07:35+00:00","dateModified":"2021-05-14T11:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/"},"wordCount":341,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png","keywords":["Power BI to OBIEE"],"articleSection":["Solution Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/","url":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/","name":"Power BI OBIEE Connector challenges and best practices","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png","datePublished":"2020-11-24T11:07:35+00:00","dateModified":"2021-05-14T11:34:17+00:00","description":"Here's a quick snapshot of the various challenges in connecting Power BI to OBIEE, and the best practices to overcome them.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Power-BI-OBIEE-challenges-best-practices.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/power-bi-obiee-connector-challenges-and-best-practices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Challenges in Connecting Power BI to OBIEE and How to Overcome Them?"}]},{"@type":"WebSite","@id":"https:\/\/www.biconnector.com\/blog\/#website","url":"https:\/\/www.biconnector.com\/blog\/","name":"BI connector Blog","description":"Blog on BI, Analytics, and Integration","publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.biconnector.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.biconnector.com\/blog\/#organization","name":"BI Connector","url":"https:\/\/www.biconnector.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2018\/09\/logo-1.svg","width":1,"height":1,"caption":"BI Connector"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/biconnector","https:\/\/x.com\/bi_connector","https:\/\/www.linkedin.com\/company\/bi-connector","https:\/\/www.youtube.com\/channel\/UCDZO-hi2HzjeGChmbjQAW-w"]},{"@type":"Person","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9","name":"BI Connector Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7160ad63033671078ece993f850d16b3?s=96&d=wavatar&r=g","caption":"BI Connector Team"},"sameAs":["https:\/\/www.biconnector.com"],"url":"https:\/\/www.biconnector.com\/blog\/author\/bi-connector-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2582"}],"collection":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/comments?post=2582"}],"version-history":[{"count":11,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2582\/revisions"}],"predecessor-version":[{"id":3204,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2582\/revisions\/3204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/2594"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=2582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=2582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=2582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}