{"id":14302,"date":"2020-06-17T06:47:19","date_gmt":"2020-06-17T04:47:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/"},"modified":"2020-06-17T06:47:19","modified_gmt":"2020-06-17T04:47:19","slug":"power-bi-report-server-url-reservation-warning-delegation-blocked","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/","title":{"rendered":"Power BI Report Server &#8211; URL reservation Warning &#8211; Delegation blocked"},"content":{"rendered":"<h3>Introduction<\/h3>\n<p>Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working fine. Where as on the development server the delegation was not working at all. We had as well a comparable behavior on the production environment, but only sporadically. The same data source worked fine for one user and suddenly no more for another one, or for the same user one data source connection was accessible but another one was failing with the well known error:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-40667\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\" alt=\"\" width=\"511\" height=\"229\" \/><\/a><\/p>\n<h3>Investigation<\/h3>\n<p>It was clear that it was a Kerberos delegation issue at first glance, therefore the first things you look at are the settings of your service account:<br \/>\n&#8211; Is &#8220;Trust for delegation&#8221; set<br \/>\n&#8211; If you use constraint delegation, check if you address the right services<\/p>\n<p>After that, we double checked that the SPN&#8217;s were still correct. Everything was fine and set as it must be.<\/p>\n<p>The next step was to check the configuration of the Power BI Report Server. So opening the Power BI Report Server Configuration Manager, I went through all the configuration settings here again everything seemed to be correct.<\/p>\n<p>Having some experiences working with Reporting Services and now with Power BI Report Server, I knew that playing and changing with the URL settings of the Web Server and the Web portal might corrupt the rsreportserver.config file, especially if you use https configuration. If you don&#8217;t understand what I&#8217;m talking about, you will sooner or later, if you have to install and configure this application often.<br \/>\nBingo, it was the first issue. There was still entries in the xml nodes that were no more valid.<\/p>\n<p>In that case my way to go is to return to the Power BI Report Server Configfuration Manager et reset the URL configurations to a default ones, deleting the ones existing in the web service and the web portal and apply the changes. After that make sure that in rsreportserver.config your tag is limited to the following example. If not, stop first your Power BI Report Server service, make first a backup of your file, than clean it and save it.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: xml; gutter: true; first-line: 1\">&lt;URLReservations&gt;\n\t&lt;Application&gt;\n\t\t&lt;Name&gt;ReportServerWebService&lt;\/Name&gt;\n\t\t&lt;VirtualDirectory&gt;ReportServer&lt;\/VirtualDirectory&gt;\n\t\t&lt;URLs&gt;\n\t\t\t&lt;URL&gt;\n\t\t\t\t&lt;UrlString&gt;http:\/\/+:80&lt;\/UrlString&gt;\n\t\t\t\t&lt;AccountSid&gt;S-1-5-80-1730998386-2757299892-37364343-1607169425-3512908663&lt;\/AccountSid&gt;\n\t\t\t\t&lt;AccountName&gt;NT SERVICE\\PowerBIReportServer&lt;\/AccountName&gt;\n\t\t\t&lt;\/URL&gt;\n\t\t&lt;\/URLs&gt;\n\t&lt;\/Application&gt;\n\t&lt;Application&gt;\n\t\t&lt;Name&gt;ReportServerWebApp&lt;\/Name&gt;\n\t\t&lt;VirtualDirectory&gt;Reports&lt;\/VirtualDirectory&gt;\n\t\t&lt;URLs&gt;\n\t\t\t&lt;URL&gt;\n\t\t\t\t&lt;UrlString&gt;http:\/\/+:80&lt;\/UrlString&gt;\n\t\t\t\t&lt;AccountSid&gt;S-1-5-80-1730998386-2757299892-37364343-1607169425-3512908663&lt;\/AccountSid&gt;\n\t\t\t\t&lt;AccountName&gt;NT SERVICE\\PowerBIReportServer&lt;\/AccountName&gt;\n\t\t\t&lt;\/URL&gt;\n\t\t&lt;\/URLs&gt;\n\t&lt;\/Application&gt;\n&lt;\/URLReservations&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>Make sure as well that at the end of the file you do not have a tag . If you have one, delete the whole tag from to the end of and save you file again.<\/p>\n<p>\u2026of course restart your Power BI Report Server service after that<\/p>\n<p>Now that my configuration file was clean, I tried again to set up again my HTTPS configuration for my web service and web portal the configuration manager tool. When you do it, please look carefully at the scrolling messages at the bottom of the configuration manager to see if it the settings apply successfully. For me it was full of green lights and the end message as well.<\/p>\n<p>But, do not miss to read carefully the warnings. Right at the beginning one message was warning that the URL could not be reserved, but the following one said the URL has been removed and the next one that it was reserved successfully. So why to worry!!?? Just because my issue with Kerberos was still not solved.<\/p>\n<h3>URL Reservation list<\/h3>\n<p>Therefore I decided to follow this strange warning and search information about reserved URL.<br \/>\nI found out the following command to execute to see what were the URL&#8217;s reserved on my server and discover all that were reserved by the user NT SERVICE\\PowerBIReportServer.<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">netsh http show urlacl<\/pre>\n<p>Then again I reset my URL configurations and clean my rsreportserver.config file once more<\/p>\n<h3>Removing URL Reservation<\/h3>\n<p>This time I left my Power BI Report Server service stopped and removed manually all the reserved URL linked to the user NT SERVICE\\PowerBIReportServer. You should find always 4 URL&#8217;s, one for the Web service with the folder you used (in mase case \u2026\/ReportServer), one for the Web Portal with the folder you defined (in\u2026\/Reports), another folder named \/PowerBI and the last one \/wopi.<\/p>\n<pre class=\"brush: powershell; gutter: true; first-line: 1\">netsh http delete urlacl https:\/\/yourserver.yourdomain.com:443\/ReportServer\/\nnetsh http delete urlacl https:\/\/yourserver.yourdomain.com:443\/Reports\/\nnetsh http delete urlacl https:\/\/yourserver.yourdomain.com:443\/PowerBI\/\nnetsh http delete urlacl https:\/\/yourserver.yourdomain.com:443\/wopi\/<\/pre>\n<p>You can remove all the URL leaving on the leave only the one<br \/>\nWith +80 and +8083 in the URL.<\/p>\n<p>Then start your configuration manager again et make the URL configuration looking at the scrolling messages at the bottom. Normally no warnings will be displayed anymore.<\/p>\n<h3>\u2026 and finally<\/h3>\n<p>Well, when I was finished, I tested again my data sources connections and by magic all worked perfectly and the delegation was successfully done.<br \/>\nI hope this post will help you and save you time, it took me some hours to figure out that the URL reservation was causing delegation issues.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working fine. Where as on the development server the delegation was not working at all. We [&hellip;]<\/p>\n","protected":false},"author":38,"featured_media":14303,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294],"tags":[902,2000,2001,444,1496,2002],"type_dbi":[],"class_list":["post-14302","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-configuration","tag-data-source","tag-delegation","tag-kerberos","tag-power-bi-report-server","tag-url-reservation"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Power BI Report Server - URL reservation Warning - Delegation blocked - dbi Blog<\/title>\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.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Report Server - URL reservation Warning - Delegation blocked\" \/>\n<meta property=\"og:description\" content=\"Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working fine. Where as on the development server the delegation was not working at all. We [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-17T04:47:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"511\" \/>\n\t<meta property=\"og:image:height\" content=\"229\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christophe Cosme\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"Power BI Report Server &#8211; URL reservation Warning &#8211; Delegation blocked\",\"datePublished\":\"2020-06-17T04:47:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\"},\"wordCount\":793,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\",\"keywords\":[\"configuration\",\"Data Source\",\"Delegation\",\"Kerberos\",\"Power BI Report Server\",\"URL Reservation\"],\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\",\"name\":\"Power BI Report Server - URL reservation Warning - Delegation blocked - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\",\"datePublished\":\"2020-06-17T04:47:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg\",\"width\":511,\"height\":229},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI Report Server &#8211; URL reservation Warning &#8211; Delegation blocked\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g\",\"caption\":\"Christophe Cosme\"},\"description\":\"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI Report Server - URL reservation Warning - Delegation blocked - dbi Blog","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.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/","og_locale":"en_US","og_type":"article","og_title":"Power BI Report Server - URL reservation Warning - Delegation blocked","og_description":"Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working fine. Where as on the development server the delegation was not working at all. We [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/","og_site_name":"dbi Blog","article_published_time":"2020-06-17T04:47:19+00:00","og_image":[{"width":511,"height":229,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg","type":"image\/jpeg"}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"Power BI Report Server &#8211; URL reservation Warning &#8211; Delegation blocked","datePublished":"2020-06-17T04:47:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/"},"wordCount":793,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg","keywords":["configuration","Data Source","Delegation","Kerberos","Power BI Report Server","URL Reservation"],"articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/","url":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/","name":"Power BI Report Server - URL reservation Warning - Delegation blocked - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg","datePublished":"2020-06-17T04:47:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/chc_blog_20200617_01.jpg","width":511,"height":229},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/power-bi-report-server-url-reservation-warning-delegation-blocked\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI Report Server &#8211; URL reservation Warning &#8211; Delegation blocked"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/736ec7a3216e381c2ef81f210f381e613297d76c2120169411c4423c3c58992c?s=96&d=mm&r=g","caption":"Christophe Cosme"},"description":"Christophe Cosme has more than 22 years of experience in architecture, development and implementation of IT solutions including 17 years in the Business Intelligence area as well as 10 years of experience working with the Microsoft SQL Server Business Intelligence suite. His experience and qualifications cover project management, business analysis, functional and technical requirements. His expertise also includes the implementation of IT solutions in national as well as international organizations. Christophe Cosme is Expert in MS SQL Server DB Engine, SSIS, SSAS, SSRS and PowerBI. Prior to joining dbi services, Christophe Cosme was Solution Lead Business Intelligence Diabetes Care at Hoffmann-La-Roche Ltd in Basel . He also worked as Senior Manager Head of Business Intelligence for Swiss International Airlines Ltd. Christophe Cosme holds a Master's degree in Engineering, Automation from the IT\u2013 ENSISA (F). His branch-related experience covers pharmaceuticals, IT and the airline sector.","url":"https:\/\/www.dbi-services.com\/blog\/author\/christophe-cosme\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14302"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14302\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14303"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14302"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}