{"id":19049,"date":"2022-09-20T11:21:09","date_gmt":"2022-09-20T09:21:09","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=19049"},"modified":"2022-09-20T11:21:10","modified_gmt":"2022-09-20T09:21:10","slug":"data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","title":{"rendered":"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>The second pre-conf I attended was about tuning Power BI.<\/p>\n\n\n\n<p>I was curious to hear and learn from Nikola&nbsp; Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues<\/p>\n\n\n\n<p>The agenda was the following over the 2&nbsp; half days<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"410\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png\" alt=\"\" class=\"wp-image-19050\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-300x120.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-768x308.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62.png 1343w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"397\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-63-1024x397.png\" alt=\"\" class=\"wp-image-19051\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-63-1024x397.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-63-300x116.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-63-768x297.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-63.png 1317w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Data Modelling<\/h2>\n\n\n\n<p>Nikola first explain why data modelling is so important and especially why a star schema is so useful and adequate for analyzing your data.<\/p>\n\n\n\n<p>Even if sometime a star schema is not performing as well as flat table it remains an exception, and a star-schema model will always to be privileged.<\/p>\n\n\n\n<p>Having so many year of experience in data warehousing and BI modelling, I was of course alreay aware of that and could only agree with Nikola on that point, but it is always good to hear that the fundamental rules must be applied first.<\/p>\n\n\n\n<p>The more time you spend in your data model the less DAX complexity you will have.<\/p>\n\n\n\n<p>It is also important to avoid<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>one-to-one relationship<\/li><li>Bi-directional relationship:<\/li><\/ul>\n\n\n\n<p>You can easily avoid such this one applying not blank filter to filter out data in other visuals with related data<\/p>\n\n\n\n<p>Use CROSSFILTER function iso bi-directional relationship especially for dimension to dimension cross analysis<\/p>\n\n\n\n<p>A clear knowledge of the Vertipaq engine is also necessary to understand that you need to reduce the cardinality of the column at a minimum and to keep the model to a minimum size to get the best possible performances.<\/p>\n\n\n\n<p>So keep in mind to always reduce you model to the granularity you need and remove all the information need necessary.<\/p>\n\n\n\n<p>There are some techniques to reduce easily the size of the model, for instance to separate the time and the date in separate column to reduce heavily the cardinality of a sing datetime column.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Some techniques to have in mind<\/h2>\n\n\n\n<p><strong>Auto Date\/time<\/strong><\/p>\n\n\n\n<p>The auto date\/time feature seems to be very practical at first.<\/p>\n\n\n\n<p>But it can destroy your data model. It generate a lot of hidden data table for each your date\/time columns and depending of the range you have can be very huge amount of data generated.<\/p>\n\n\n\n<p>And it can be ugly when using slow changing dimensions.<\/p>\n\n\n\n<p>So avoid definitely to use it a make your own date dimension that you can control.<\/p>\n\n\n\n<p><strong>Data Shaping<\/strong><\/p>\n\n\n\n<p>Best practice is always to shape your data, transformation and calculation as upstream as possible and as downstream as necessary. I&nbsp; other word it is better to do it before landing data in Power BI if possible.<\/p>\n\n\n\n<p><strong>Query folding<\/strong><\/p>\n\n\n\n<p>Query folding is the ability to translate the query in a query that can be interpreted by the source system. This avoid the Power Query Engine to work locally on the data. So the data can be delivered more quickly.<\/p>\n\n\n\n<p>Check always when defining the query if it is folding or if the steps applied break the query folding. This is very important especially in DirectQuery mode. But consider it as well in import mode. The data import might perform much quicker if the query folds.<\/p>\n\n\n\n<p><strong>DAX calculations<\/strong><\/p>\n\n\n\n<p>When you use DAX calculations in your model, it is also important to know how they behave.<\/p>\n\n\n\n<p>You can use the Power BI desktop Query Analyzer to capture the DAX formula applied in your visual an copy it in DAX Studio to analyze it further and understand if you can optimize it.<\/p>\n\n\n\n<p>Understanding what is the Formula Engine (FE) and the Storage Engine (SE) of Power BI helps to optimize the DAX queries, especially to avoid the CallbackDataID slowing down the execution of the query.<\/p>\n\n\n\n<p>Here are the steps to follow in for DAX calculation optimization:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"196\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-67-1024x196.png\" alt=\"\" class=\"wp-image-19055\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-67-1024x196.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-67-300x58.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-67-768x147.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-67.png 1450w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Aggregations<\/strong><\/p>\n\n\n\n<p>Aggregation tables can be define only if in case of DirectQuery mode.<\/p>\n\n\n\n<p>You have to make Power BI aware of the aggregated tables. It can speed up considerably the query when you defined aggregated table on column frequently used in your visuals.<\/p>\n\n\n\n<p>It enables Power BI to pre-aggregate the data you detailed table and keep it in memory.<\/p>\n\n\n\n<p>But be careful using the aggregation it might lead to inconsistency of your report result when visuals can grab the data from the aggregated tables and some other must query the source system to get the needed data.<\/p>\n\n\n\n<p><strong>Visual rendering time<\/strong><\/p>\n\n\n\n<p>Interesting was the see that each visual is waiting for the other to render the result. This is due to the single-threaded Formula Engine.<\/p>\n\n\n\n<p>Replacing individual Cards visuals by a Matrix with the same measures can improve the rendering time.<\/p>\n\n\n\n<p>Of course limiting the number of visual will also improve the performance of your report.<\/p>\n\n\n\n<p>Sync Slicer can be as well a cause of a low performing report.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Performance tuner toolbox<\/h2>\n\n\n\n<p>To analyze the performances of your Power BI report there are some tools to know that can be of a great help.<\/p>\n\n\n\n<p>First tool is the performance analyzer available in the Power BI desktop. It is the first step to identify element responsible of slow performance. It enables to capture information in real-time when you report is executing.<\/p>\n\n\n\n<p>You will get information about times needed for:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DAX Query<\/li><li>Visual display<\/li><li>Other: wait time for other visuals to finish<\/li><li>Evaluated parameters<\/li><\/ul>\n\n\n\n<p>Outside the Power BI desktop there are a lot of external tools that are develop by third-party contributor but not officially supported by Microsoft.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DAX studio: <a href=\"https:\/\/daxstudio.org\">https:\/\/daxstudio.org<\/a><\/li><\/ul>\n\n\n\n<p>It very good tool to analyze your data model, it give you the size of the data, table, columns, give you information about the relationships and partitions. You can also analyze your data queries in order to see the query plan and find the potential optimization.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Tabular editor: <a href=\"https:\/\/www.sqlbi.com\/tools\/tabular-editor\/\">https:\/\/www.sqlbi.com\/tools\/tabular-editor\/<\/a><ul><li>There is a free version and a commercial one<\/li><li>Best Practice Analyzer is an additional module that you can use<\/li><\/ul><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Very good session. I learn a lot about Power BI optimization especially on the DAX optimization part where I had the less know-how. Attending such event is proves always that we need to stay aware of all the new techniques and tools and gives you a flavor how to work with them and to be keen to try them and use them.<\/p>\n\n\n\n<p>I thanks also again Nikola for the great session and his enthusiasm as a presenter.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction The second pre-conf I attended was about tuning Power BI. I was curious to hear and learn from Nikola&nbsp; Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues The agenda was the following over the 2&nbsp; half days Data Modelling Nikola first explain why data [&hellip;]<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,368],"tags":[644,1490],"type_dbi":[],"class_list":["post-19049","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-development-performance","tag-performance-tuning","tag-power-bi"],"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>Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day! - 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\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day!\" \/>\n<meta property=\"og:description\" content=\"Introduction The second pre-conf I attended was about tuning Power BI. I was curious to hear and learn from Nikola&nbsp; Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues The agenda was the following over the 2&nbsp; half days Data Modelling Nikola first explain why data [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-20T09:21:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-20T09:21:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png\" \/>\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=\"6 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\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\"},\"author\":{\"name\":\"Christophe Cosme\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"headline\":\"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!\",\"datePublished\":\"2022-09-20T09:21:09+00:00\",\"dateModified\":\"2022-09-20T09:21:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\"},\"wordCount\":1054,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png\",\"keywords\":[\"Performance Tuning\",\"Power BI\"],\"articleSection\":[\"Business Intelligence\",\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\",\"name\":\"Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day! - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png\",\"datePublished\":\"2022-09-20T09:21:09+00:00\",\"dateModified\":\"2022-09-20T09:21:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62.png\",\"width\":1343,\"height\":538},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!\"}]},{\"@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":"Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day! - 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\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","og_locale":"en_US","og_type":"article","og_title":"Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day!","og_description":"Introduction The second pre-conf I attended was about tuning Power BI. I was curious to hear and learn from Nikola&nbsp; Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues The agenda was the following over the 2&nbsp; half days Data Modelling Nikola first explain why data [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","og_site_name":"dbi Blog","article_published_time":"2022-09-20T09:21:09+00:00","article_modified_time":"2022-09-20T09:21:10+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png","type":"","width":"","height":""}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christophe Cosme","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/"},"author":{"name":"Christophe Cosme","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"headline":"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!","datePublished":"2022-09-20T09:21:09+00:00","dateModified":"2022-09-20T09:21:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/"},"wordCount":1054,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png","keywords":["Performance Tuning","Power BI"],"articleSection":["Business Intelligence","Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","url":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","name":"Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day! - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62-1024x410.png","datePublished":"2022-09-20T09:21:09+00:00","dateModified":"2022-09-20T09:21:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5cbf7c261d165a45977c85f535d6cb6a"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-62.png","width":1343,"height":538},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!"}]},{"@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\/19049","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=19049"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19049\/revisions"}],"predecessor-version":[{"id":19058,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19049\/revisions\/19058"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=19049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=19049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=19049"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=19049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}