{"id":768,"date":"2017-11-15T18:37:15","date_gmt":"2017-11-15T18:37:15","guid":{"rendered":"https:\/\/dev.biconnector.com\/blog\/?p=768"},"modified":"2019-08-27T09:47:38","modified_gmt":"2019-08-27T09:47:38","slug":"power-bi-obiee-directquery-import-odbc","status":"publish","type":"post","link":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/","title":{"rendered":"Power BI to OBIEE: DirectQuery, Import or ODBC?"},"content":{"rendered":"<p>To connect and visualize OBIEE with Power BI Desktop using BI Connector, users have three options: DirectQuery, Import, and ODBC.\u00a0 In this article, we will review the details of these three options.<\/p>\n<h2>DirectQuery<\/h2>\n<p>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.\u00a0 As you create visualizations by choosing the columns, data is queried from OBIEE via BI Connector.\u00a0 You always see the current data in OBIEE.\u00a0 DirectQuery works well with large multi-dimensional data sources such as OBIEE.<\/p>\n<p>BI Connector team has worked closely with the Power BI team to optimize the DirectQuery performance for OBIEE.\u00a0 As a result, you can view the OBIEE Subject Areas and Reports metadata quickly even if you have a large data warehouse.<\/p>\n<p>To connect to OBIEE Subject Areas and Reports from Power BI Desktop using DirectQuery, please refer to the following step-by-step guides:<\/p>\n<ul>\n<li><a href=\"http:\/\/support.biconnector.com\/solution\/articles\/8000048783-connect-power-bi-desktop-to-obiee-reports-using-direct-query-step-by-step-user-guide\" target=\"_blank\" rel=\"noopener\" data-pjax=\"#body-container\">Connect Power BI Desktop to OBIEE Reports using Direct Query &#8211; Step-by-Step User Guide<\/a><\/li>\n<li><a href=\"http:\/\/support.biconnector.com\/solution\/articles\/8000048779-connect-power-bi-desktop-to-obiee-subject-areas-using-direct-query-step-by-step-user-guide\" target=\"_blank\" rel=\"noopener\" data-pjax=\"#body-container\">Connect Power BI Desktop to OBIEE Subject Areas using Direct Query &#8211; Step-by-Step User Guide<\/a><\/li>\n<\/ul>\n<p>Power BI On-premise Gateway supports Direct Query for BI Connector based data sources.\u00a0 So, you can publish your Direct Query report to Power BI service and connect live to data from OBIEE.\u00a0 \u00a0<em>\u00a0<\/em>To manage the security of the imported OBIEE data, use Power BI&#8217;s security model.<\/p>\n<p>&nbsp;<\/p>\n<h2>Import<\/h2>\n<p>Import first copies the OBIEE data into Power BI Desktop.\u00a0 You can create visualizations using the imported data.\u00a0 To see the current data in OBIEE, you have to refresh the data.<\/p>\n<p>Import uses Power BI&#8217;s in-memory database(cache) for fast analysis.\u00a0 \u00a0However, you should use filters to import only the required data into Power BI Desktop.\u00a0 Failure to do so could result in query performance issues.<\/p>\n<p>To import OBIEE data, the steps are similar to DirectQuery. In the connection UI, choose Import instead of DirectQuery.\u00a0 Importing OBIEE reports is straightforward.\u00a0 The report is available as a table in Power BI<em>.\u00a0<\/em> To import Subject Areas, merge the folders\/tables into a single table using GZID which is a BI Connector specific column.\u00a0 You can then import the merged table into Power BI with appropriate data filters.<\/p>\n<p>To connect to OBIEE Reports and Subject Areas from Power BI Desktop using Import, follow the same steps as Direct Query, but choose Import instead of DirectQuery in the connection type.<\/p>\n<p>Power BI On-premise Gateway supports scheduled refresh of datasets for BI Connector based data sources.\u00a0 So, you can publish your datasets and report to Power BI service and schedule daily or weekly refresh of data from OBIEE.\u00a0 \u00a0<em>\u00a0<\/em>To manage the security of the imported OBIEE data, use Power BI&#8217;s security model.<\/p>\n<h2>ODBC<\/h2>\n<p>ODBC connection is similar to import. When you connect to OBIEE, Power BI imports the data into its in-memory cache<em>.<\/em>\u00a0 You can create visualizations from the imported data.\u00a0 To see the current data in OBIEE, you should refresh.<\/p>\n<p>ODBC connection to OBIEE using BI Connector uses Power BI in-memory cache. Therefore, the performance characteristics of ODBC approach are similar to that of the Import.\u00a0 We strongly recommend that you use filters to bring only the required data from OBIEE into Power BI.<\/p>\n<p>To connect Power BI to OBIEE using BI Connector as a ODBC data source,\u00a0check out the following step-by-step guides:<\/p>\n<ul>\n<li><a class=\"c-link\" href=\"http:\/\/support.biconnector.com\/support\/solutions\/articles\/8000059242-connect-from-power-bi-desktop-to-obiee-reports-using-odbc-dsn-connection-step-by-step-user-guide\">Connect from Power BI Desktop to OBIEE Reports using ODBC DSN Connection &#8211; Step-by-Step User Guide<\/a><\/li>\n<li>\n<div class=\"ellipsis article-title\"><a class=\"c-link\" href=\"http:\/\/support.biconnector.com\/support\/solutions\/articles\/8000055184-connect-power-bi-gateway-to-obiee-reports-via-bi-connector-as-odbc-connection-step-by-step-user-gui\">Connect Power BI Gateway to OBIEE Reports via BI Connector as ODBC connection &#8211; Step-by-Step User Guide<\/a><\/div>\n<\/li>\n<\/ul>\n<p>Power BI On-premise Gateway supports scheduled refresh of datasets for ODBC data sources.\u00a0 So, you can publish your datasets and report to Power BI service and schedule daily or weekly refresh of data from OBIEE.\u00a0 \u00a0<em>\u00a0<\/em>To manage the security of the imported OBIEE data, use Power BI&#8217;s security model.<\/p>\n<h2>Summary<\/h2>\n<p>When it comes to connecting from Power BI to OBIEE using BI Connector you have the option of using DirectQuery, ODBC or Import.\u00a0 Choose the approach depending upon your business requirement, environment, and expertise level of users.<\/p>\n<p>If you have questions about best practices for connecting Power BI to OBIEE, or would like to see a demo, <a href=\"https:\/\/dev.biconnector.com\/contact-us\/\" target=\"_blank\" rel=\"noopener\">drop us a note<\/a>.\u00a0 We will schedule a web conference session at your convenience to answer your questions.<\/p>\n<p>Happy Easy Analytics!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To connect and visualize OBIEE with Power BI Desktop using BI Connector, users have three options: DirectQuery, Import, and ODBC.\u00a0 In this article, we will review the details of these three options. DirectQuery When you use DirectQuery, Power BI Desktop does not import or copy the OBIEE data. You can view the list of columns [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[120],"tags":[69,70,12,23,59],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog<\/title>\n<meta name=\"description\" content=\"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog\" \/>\n<meta property=\"og:description\" content=\"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/\" \/>\n<meta property=\"og:site_name\" content=\"BI connector Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-15T18:37:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-27T09:47:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.biconnector.com\/blog\/wp-content\/uploads\/2017\/11\/Woman-looking-at-a-computer.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"BI Connector Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/\",\"url\":\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/\",\"name\":\"Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog\",\"isPartOf\":{\"@id\":\"https:\/\/dev.biconnector.com\/blog\/#website\"},\"datePublished\":\"2017-11-15T18:37:15+00:00\",\"dateModified\":\"2019-08-27T09:47:38+00:00\",\"author\":{\"@id\":\"https:\/\/dev.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"description\":\"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dev.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI to OBIEE: DirectQuery, Import or ODBC?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.biconnector.com\/blog\/#website\",\"url\":\"https:\/\/dev.biconnector.com\/blog\/\",\"name\":\"BI connector Blog\",\"description\":\"Blog on BI, Analytics, and Integration\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.biconnector.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dev.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\",\"name\":\"BI Connector Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dev.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:\/\/dev.biconnector.com\/blog\/author\/bi-connector-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog","description":"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog","og_description":"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0","og_url":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/","og_site_name":"BI connector Blog","article_published_time":"2017-11-15T18:37:15+00:00","article_modified_time":"2019-08-27T09:47:38+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/dev.biconnector.com\/blog\/wp-content\/uploads\/2017\/11\/Woman-looking-at-a-computer.jpg","type":"image\/jpeg"}],"author":"BI Connector Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"BI Connector Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/","url":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/","name":"Power BI to OBIEE: DirectQuery, Import or ODBC? - BI connector Blog","isPartOf":{"@id":"https:\/\/dev.biconnector.com\/blog\/#website"},"datePublished":"2017-11-15T18:37:15+00:00","dateModified":"2019-08-27T09:47:38+00:00","author":{"@id":"https:\/\/dev.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"description":"You can connect from Power BI to OBIEE with BI Connector using DirectQuery, ODBC or Import.\u00a0 This article discusses the pros and cons of each approach. \u00a0","breadcrumb":{"@id":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.biconnector.com\/blog\/power-bi-obiee-directquery-import-odbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI to OBIEE: DirectQuery, Import or ODBC?"}]},{"@type":"WebSite","@id":"https:\/\/dev.biconnector.com\/blog\/#website","url":"https:\/\/dev.biconnector.com\/blog\/","name":"BI connector Blog","description":"Blog on BI, Analytics, and Integration","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.biconnector.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/dev.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9","name":"BI Connector Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.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:\/\/dev.biconnector.com\/blog\/author\/bi-connector-team\/"}]}},"_links":{"self":[{"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/768"}],"collection":[{"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/comments?post=768"}],"version-history":[{"count":7,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/768\/revisions"}],"predecessor-version":[{"id":1374,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/768\/revisions\/1374"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/771"}],"wp:attachment":[{"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}