{"id":2543,"date":"2020-11-10T15:47:17","date_gmt":"2020-11-10T15:47:17","guid":{"rendered":"https:\/\/www.biconnector.com\/blog\/?p=2543"},"modified":"2021-05-14T11:34:17","modified_gmt":"2021-05-14T11:34:17","slug":"how-to-optimize-query-performance-when-connecting-power-bi-to-obiee","status":"publish","type":"post","link":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/","title":{"rendered":"How to Optimize Query Performance When Connecting Power BI to OBIEE?"},"content":{"rendered":"<p>When connecting Power BI to Oracle Business Intelligence Enterprise Edition (OBIEE), the users could encounter performance issues for certain queries.<\/p>\n<p>In this blog post, we\u2019ll see how you can optimize the query performance when <a href=\"https:\/\/www.biconnector.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">connecting Power BI to OBIEE<\/a> (or <a href=\"https:\/\/www.biconnector.com\/blog\/oracle-analytics-cloud-oac-guide\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Analytics Cloud (OAC)<\/a> \/ Oracle Analytics Server (OAS) ) via BI Connector.<\/p>\n<p>Let&#8217;s dive into the details!<\/p>\n<h1>Fine-tune BI Connector Query Limit parameters<\/h1>\n<p>You can see the following 3 parameters in the Query Limits section of the BI Connector Advanced Settings window:<\/p>\n<ol>\n<li>Maximum number of rows per report<\/li>\n<li>Maximum number of rows per fetch<\/li>\n<li>Maximum number of columns per query<\/li>\n<\/ol>\n<p>The query limits section is highlighted in the below image.<br \/>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-2376\" src=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/BI-Connector-Advanced-Settings.png\" alt=\"BI Connector Advanced Settings for optimizing query performance\" \/><\/p>\n<div style=\"font-size: 18px; margin-bottom: 30px; background-color: #ecf7ed; padding: 20px; border-radius: 6px; font-weight: bold;\">\u22d9 Here\u2019s our simplified guide to the comparison of<a href=\"https:\/\/www.biconnector.com\/blog\/power-bi-vs-obiee-comparison\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Power BI Vs OBIEE<\/a>.<\/div>\n<p>Now let\u2019s take a quick look at each of these parameters:<\/p>\n<ul>\n<li><b>Maximum number of rows per report<\/b><\/li>\n<\/ul>\n<p><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><br \/>\nThe parameter, Maximum number of rows per report, help you to restrict the maximum number of rows you want BI Connector to fetch for a query.<\/p>\n<p>For example, let\u2019s consider an OBIEE report you want to analyze has more than 1,000,000 rows. But you want to analyze just the first 100,000 rows.<\/p>\n<p>In that case, you can set the Maximum number of rows per report as 100,000. So, BI Connector would fetch only the first 100,000 rows for all your queries, and ignore the rest of the rows, if there\u2019s any.<br \/>\n<b><\/b><\/p>\n<ul>\n<li><b>Maximum number of rows per fetch<\/b><\/li>\n<\/ul>\n<p><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><br \/>\nThe parameter, Maximum number of rows per fetch, will help you avoid OBIEE time-out errors smartly.<\/p>\n<p>For example, let\u2019s say you want to analyze an OBIEE report with 100,000 rows. In this case, you can set the Maximum number of rows per fetch as 50,000. Therefore, BI Connector will fetch the first 50,000 rows in the first batch, and the remaining in the next batch.<\/p>\n<p>The setting will help you avoid time-out errors as well. But you should ensure that the maximum number of rows per fetch is set to be less than the <b>ResultRowLimit<\/b> specified in your <b>OBIEE instance config file<\/b>.<br \/>\nIf you\u2019re not aware of the limit set in the ResultRowLimit parameter, you can have a chat with your OBIEE administrator, and get that information.<br \/>\n<b><\/b><\/p>\n<ul>\n<li><b>Maximum number of columns per query<\/b><\/li>\n<\/ul>\n<p><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><b><\/b><br \/>\nThe parameter, Maximum number of columns per query, will help you restrict the number of columns BI Connector fetches from your <a href=\"https:\/\/www.biconnector.com\/blog\/obiee-guide-to-oracle-bi-data-visualization\/\" target=\"_blank\" rel=\"noopener noreferrer\">OBIEE<\/a> for your analysis.<br \/>\nAlways have the Maximum number of columns per query value to be set <b>more than the number of columns you want to analyze<\/b>.<\/p>\n<p>If the value you set in this parameter is less than the number of columns in your OBIEE report, you\u2019ll see an error message. BI Connector&#8217;s recommendation is to reduce the number of columns as much as possible to improve query performance.<\/p>\n<p>With these 3 settings in BI Connector: Advanced Settings window, you can easily optimize your query performance when connecting Power BI to OBIEE or OAC or OAS.<\/p>\n<p>Another simple technique (that\u2019s often overlooked) to improve your query performance is to apply filters! You can easily apply filters, and narrow down to the data that you need for your analysis.<\/p>\n<p>Important Note: From BI Connector v5.3, the Maximum number of rows per report and Maximum number of Columns per query parameters are deprecated. For more info, please refer to <a href=\"https:\/\/www.biconnector.com\/blog\/bi-connector-v5-3-is-released-actionable-error-messages-and-smooth-data-volume-handling\/\" target=\"_blank\" rel=\"noopener noreferrer\">this post<\/a>.<\/p>\n<p>In fact, applying filters and the 3 parameters we just saw are a part of the <a href=\"https:\/\/info.biconnector.com\/9-power-bi-hacks-to-visualize-obiee-data-watch-webinar-recording-request\"><b>9 best practices we curated for connecting Power BI to OBIEE<\/b><\/a> (in a recent webinar), after analyzing of 1000s of customer support tickets and 100s of customer interactions.<\/p>\n<p><a href=\"https:\/\/info.biconnector.com\/9-power-bi-hacks-to-visualize-obiee-data-watch-webinar-recording-request\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2376\" src=\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/600x314-Blog-image-for-LinkedIn-10.png\" alt=\"Power BI OBIEE OAC Best Practices\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When connecting Power BI to Oracle Business Intelligence Enterprise Edition (OBIEE), the users could encounter performance issues for certain queries. In this blog post, we\u2019ll see how you can optimize the query performance when connecting Power BI to OBIEE (or Oracle Analytics Cloud (OAC) \/ Oracle Analytics Server (OAS) ) via BI Connector. Let&#8217;s dive [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":2546,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[76,78],"tags":[12,59,90,143],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog<\/title>\n<meta name=\"description\" content=\"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.\" \/>\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\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog\" \/>\n<meta property=\"og:description\" content=\"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\" \/>\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-10T15:47:17+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\/Simplified-Performance-Tuning.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1256\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\"},\"author\":{\"name\":\"BI Connector Team\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9\"},\"headline\":\"How to Optimize Query Performance When Connecting Power BI to OBIEE?\",\"datePublished\":\"2020-11-10T15:47:17+00:00\",\"dateModified\":\"2021-05-14T11:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\"},\"wordCount\":601,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png\",\"keywords\":[\"OBIEE\",\"Power BI\",\"Power BI to OBIEE\",\"Webinar\"],\"articleSection\":[\"Solution Articles\",\"Webinars\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\",\"url\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\",\"name\":\"How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png\",\"datePublished\":\"2020-11-10T15:47:17+00:00\",\"dateModified\":\"2021-05-14T11:34:17+00:00\",\"description\":\"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage\",\"url\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png\",\"contentUrl\":\"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png\",\"width\":2400,\"height\":1256,\"caption\":\"Simplified Performance Tuning\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.biconnector.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Optimize Query Performance When Connecting Power BI to OBIEE?\"}]},{\"@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":"How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog","description":"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.","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\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/","og_locale":"en_US","og_type":"article","og_title":"How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog","og_description":"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.","og_url":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/","og_site_name":"BI connector Blog","article_publisher":"https:\/\/www.facebook.com\/biconnector","article_published_time":"2020-11-10T15:47:17+00:00","article_modified_time":"2021-05-14T11:34:17+00:00","og_image":[{"width":2400,"height":1256,"url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#article","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/"},"author":{"name":"BI Connector Team","@id":"https:\/\/www.biconnector.com\/blog\/#\/schema\/person\/861351d5d0c055d8c0c6d5bde42836b9"},"headline":"How to Optimize Query Performance When Connecting Power BI to OBIEE?","datePublished":"2020-11-10T15:47:17+00:00","dateModified":"2021-05-14T11:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/"},"wordCount":601,"commentCount":0,"publisher":{"@id":"https:\/\/www.biconnector.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png","keywords":["OBIEE","Power BI","Power BI to OBIEE","Webinar"],"articleSection":["Solution Articles","Webinars"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/","url":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/","name":"How to Optimize Query Performance When Connecting Power BI to OBIEE? - BI connector Blog","isPartOf":{"@id":"https:\/\/www.biconnector.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage"},"image":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage"},"thumbnailUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png","datePublished":"2020-11-10T15:47:17+00:00","dateModified":"2021-05-14T11:34:17+00:00","description":"Learn the 3 simple BI Connector parameters to optimize query performance when connecting Power BI to OBIEE or OAC or OAS.","breadcrumb":{"@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#primaryimage","url":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png","contentUrl":"https:\/\/www.biconnector.com\/blog\/wp-content\/uploads\/2020\/11\/Simplified-Performance-Tuning.png","width":2400,"height":1256,"caption":"Simplified Performance Tuning"},{"@type":"BreadcrumbList","@id":"https:\/\/www.biconnector.com\/blog\/how-to-optimize-query-performance-when-connecting-power-bi-to-obiee\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.biconnector.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Optimize Query Performance When Connecting Power BI to OBIEE?"}]},{"@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\/2543"}],"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=2543"}],"version-history":[{"count":9,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2543\/revisions"}],"predecessor-version":[{"id":3203,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/posts\/2543\/revisions\/3203"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media\/2546"}],"wp:attachment":[{"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/media?parent=2543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/categories?post=2543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.biconnector.com\/blog\/wp-json\/wp\/v2\/tags?post=2543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}