{"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:09","modified_gmt":"2022-09-20T09:21:09","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 class=\"wp-block-paragraph\">The second pre-conf I attended was about tuning Power BI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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\/2022\/09\/image-62-1024x410.png\" alt=\"\" class=\"wp-image-19050\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-62-1024x410.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-62-300x120.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-62-768x308.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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\/2022\/09\/image-63-1024x397.png\" alt=\"\" class=\"wp-image-19051\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-63-1024x397.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-63-300x116.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-63-768x297.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">The more time you spend in your data model the less DAX complexity you will have.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">Use CROSSFILTER function iso bi-directional relationship especially for dimension to dimension cross analysis<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Some techniques to have in mind<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Auto Date\/time<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The auto date\/time feature seems to be very practical at first.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">And it can be ugly when using slow changing dimensions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So avoid definitely to use it a make your own date dimension that you can control.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Data Shaping<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><strong>Query folding<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><strong>DAX calculations<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you use DAX calculations in your model, it is also important to know how they behave.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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\/2022\/09\/image-67-1024x196.png\" alt=\"\" class=\"wp-image-19055\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-67-1024x196.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-67-300x58.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-67-768x147.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-67.png 1450w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Aggregations<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aggregation tables can be define only if in case of DirectQuery mode.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">It enables Power BI to pre-aggregate the data you detailed table and keep it in memory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><strong>Visual rendering time<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">Replacing individual Cards visuals by a Matrix with the same measures can improve the rendering time.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Of course limiting the number of visual will also improve the performance of your report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sync Slicer can be as well a cause of a low performing report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Performance tuner toolbox<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">I thanks also again Nikola for the great session and his enthusiasm as a presenter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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;&nbsp;<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[294],"tags":[644,1490],"class_list":["post-19049","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","tag-performance-tuning","tag-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Data Platform Summit 2022 - Cracking Power BI Performance Tuning In A Day! - dbi services | 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;&nbsp;\" \/>\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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-20T09:21:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-62.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1343\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Christophe Cosme\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/b22dd9799d7442e387c2f1437e4a327a\"},\"headline\":\"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!\",\"datePublished\":\"2022-09-20T09:21:09+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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"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\\\/2022\\\/09\\\/image-62-1024x410.png\",\"keywords\":[\"Performance Tuning\",\"Power BI\"],\"articleSection\":[\"Business Intelligence\"],\"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 services | 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\\\/2022\\\/09\\\/image-62-1024x410.png\",\"datePublished\":\"2022-09-20T09:21:09+00:00\",\"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\\\/2022\\\/09\\\/image-62.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b22dd9799d7442e387c2f1437e4a327a\",\"name\":\"Christophe Cosme\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CHC_web-min-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CHC_web-min-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/CHC_web-min-min-scaled.jpg\",\"caption\":\"Christophe Cosme\"},\"description\":\"With more than 30 years of experience in IT architecture, development, and implementation, Christophe Cosme specializes in Microsoft SQL Server administration and development, Business Intelligence with the Microsoft BI suite and cloud services, Power BI Azure service and Report Server, and Azure\\\/AWS cloud architecture and engineering. His background also covers project management and business analysis in global organizations. Prior to dbi services, he was Solution Lead Business Intelligence at Hoffmann-La Roche in Basel and Senior Manager Head of Business Intelligence at Swiss International Air Lines. Christophe holds a Master's degree in Engineering, Automation and IT from ENSISA.\",\"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 services | 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;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/data-platform-summit-2022-cracking-power-bi-performance-tuning-in-a-day\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2022-09-20T09:21:09+00:00","og_image":[{"width":1343,"height":538,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/image-62.png","type":"image\/png"}],"author":"Christophe Cosme","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/b22dd9799d7442e387c2f1437e4a327a"},"headline":"Data Platform Summit 2022 &#8211; Cracking Power BI Performance Tuning In A Day!","datePublished":"2022-09-20T09:21:09+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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"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\/2022\/09\/image-62-1024x410.png","keywords":["Performance Tuning","Power BI"],"articleSection":["Business Intelligence"],"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 services | 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\/2022\/09\/image-62-1024x410.png","datePublished":"2022-09-20T09:21:09+00:00","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\/2022\/09\/image-62.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b22dd9799d7442e387c2f1437e4a327a","name":"Christophe Cosme","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/CHC_web-min-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/CHC_web-min-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/09\/CHC_web-min-min-scaled.jpg","caption":"Christophe Cosme"},"description":"With more than 30 years of experience in IT architecture, development, and implementation, Christophe Cosme specializes in Microsoft SQL Server administration and development, Business Intelligence with the Microsoft BI suite and cloud services, Power BI Azure service and Report Server, and Azure\/AWS cloud architecture and engineering. His background also covers project management and business analysis in global organizations. Prior to dbi services, he was Solution Lead Business Intelligence at Hoffmann-La Roche in Basel and Senior Manager Head of Business Intelligence at Swiss International Air Lines. Christophe holds a Master's degree in Engineering, Automation and IT from ENSISA.","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":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19049\/revisions"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}