{"id":26962,"date":"2022-09-28T15:07:00","date_gmt":"2022-09-28T13:07:00","guid":{"rendered":"https:\/\/alistar.net\/?p=26962"},"modified":"2026-10-02T13:42:11","modified_gmt":"2026-10-02T11:42:11","slug":"performance-tuning-for-power-bi-dashboards","status":"publish","type":"post","link":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/","title":{"rendered":"Performance Tuning of Power BI Dashboards"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Good performance in terms of loading time is important for improving user acceptance and gaining the trust of stakeholders. That\u2019s why, in this blog, we\u2019ll focus on methods for reducing loading times and improving report performance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post, we'll focus on the two most important ways to improve the performance of a Power BI dashboard: the data model and the visualizations in the report.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data Model<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Within a model, you want fields with a specific data type to always be displayed in the same way. For example, with a simple script, you can set the format for all date fields, format all percentages the same way, or display all currency fields with the same number of decimal places.\u00a0Below is an example of how to set a fixed date format for all date fields.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Optimize the model<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You should always keep a Tabular Model as small and clean as possible. By using a number of scripts and methods, you can optimize the data model using Tabular Editor. Here are a few examples to consider:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set fields that are used in relationships but not in visualizations to invisible<\/li>\n\n\n\n<li>Hide fields in the model that are used in measured values but not in visualizations<\/li>\n\n\n\n<li>Remove unnecessary fields from the model<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Notices<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When adding new tables or aliases (calculated tables), the default aggregation for the fields is set to \u201cDefault.\u201d This means that all numeric fields are summed by default. Of course, this can be quickly and easily adjusted within Tabular Editor itself, but with a script, you can apply this change to the entire model at once, or only to specific cases or certain data types.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Perspectives<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Perspectives are a useful feature of a Tabular Model. Within a large model, perspectives can help ensure that the model remains user-friendly and easy to navigate for the customer (e.g., Finance, Supply Chain). When adding fields or new dimensions, updating the perspectives is often overlooked, causing them to become incomplete and increasingly difficult for end users to navigate. A script that cycles through a model\u2019s relationships and adds the tables to the perspectives resolves this issue.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Analyze further<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In addition to the methods mentioned above, you can take an even closer look at how your metrics are structured. As the well-known saying goes, \u201cAll roads lead to Rome.\u2019 The same applies to DAX calculations. But not all calculations (\u2019paths\u201c) are equally effective. The Performance Analyzer in Power BI can help with this. This tool shows exactly how long it takes to load elements and visuals.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you\u2019ve identified the pain points, you can determine which metrics could be improved. With DAX Studio, you can then further analyze the calculations behind these metrics by testing whether other DAX calculations work better to achieve the same result. It\u2019s good to know that DAX Studio is included in Power BI as an extension\/add-on.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Vertipaq Analyzer allows you to examine the data in a more general sense. How much data is there within each column, how diverse is a column, and how many rows of data does it contain?.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post, I\u2019ll share just a few ways to improve the performance of a Power BI dashboard. The scripting language is incredibly powerful and offers many options for automating and standardizing processes in your model. With just a few standard scripts, you can already fine-tune various aspects of different models, which saves you a lot of work.\u00a0If necessary, you can perform further analysis using tools like DAX Studio and Vertipaq Analyzer when certain visuals are causing reports to run slowly. For more information on how to optimize a model, see this <a href=\"https:\/\/alistar.net\/en\/tabular-model-memory-optimaliseren\/\">blog<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Good performance in terms of loading time is important for improving user acceptance and gaining the trust of stakeholders. That\u2019s why, in this blog, we\u2019ll focus on methods for reducing loading times and improving report performance.<\/p>","protected":false},"author":16,"featured_media":28551,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[203],"industrie-type":[],"interesses":[],"techologie":[],"alistar_language":[],"class_list":["post-26962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-nl","tag-powerbi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Performance tuning van Power BI dashboards - Alistar<\/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:\/\/alistar.net\/en\/blog\/performance-tuning-for-power-bi-dashboards\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance tuning van Power BI dashboards - Alistar\" \/>\n<meta property=\"og:description\" content=\"Goede prestaties op het gebied van laadtijd zijn belangrijk om gebruikersacceptatie te verbeteren en om vertrouwen te winnen bij stakeholders. Vandaar dat we in dit blog aandacht besteden aan methoden om laadtijden te verkleinen en prestaties van rapporten te verbeteren.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/alistar.net\/en\/blog\/performance-tuning-for-power-bi-dashboards\/\" \/>\n<meta property=\"og:site_name\" content=\"Alistar\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-28T13:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-02T11:42:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1610\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Shardae Castelen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shardae Castelen\" \/>\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:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/\"},\"author\":{\"name\":\"Shardae Castelen\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\"},\"headline\":\"Performance tuning van Power BI dashboards\",\"datePublished\":\"2022-09-28T13:07:00+00:00\",\"dateModified\":\"2026-10-02T11:42:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/\"},\"wordCount\":631,\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/shutterstock_2633166915-scaled.webp\",\"keywords\":[\"Power BI\"],\"articleSection\":[\"Blog NL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/\",\"name\":\"Performance tuning van Power BI dashboards - Alistar\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/shutterstock_2633166915-scaled.webp\",\"datePublished\":\"2022-09-28T13:07:00+00:00\",\"dateModified\":\"2026-10-02T11:42:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#primaryimage\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/shutterstock_2633166915-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/shutterstock_2633166915-scaled.webp\",\"width\":2560,\"height\":1610},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/performance-tuning-van-power-bi-dashboards\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/alistar.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance tuning van Power BI dashboards\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"name\":\"Alistar\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/alistar.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\",\"name\":\"Alistar\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"width\":260,\"height\":260,\"caption\":\"Alistar\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/alistar\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\",\"name\":\"Shardae Castelen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"caption\":\"Shardae Castelen\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance Tuning for Power BI Dashboards - Alistar","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:\/\/alistar.net\/en\/blog\/performance-tuning-for-power-bi-dashboards\/","og_locale":"en_US","og_type":"article","og_title":"Performance tuning van Power BI dashboards - Alistar","og_description":"Goede prestaties op het gebied van laadtijd zijn belangrijk om gebruikersacceptatie te verbeteren en om vertrouwen te winnen bij stakeholders. Vandaar dat we in dit blog aandacht besteden aan methoden om laadtijden te verkleinen en prestaties van rapporten te verbeteren.","og_url":"https:\/\/alistar.net\/en\/blog\/performance-tuning-for-power-bi-dashboards\/","og_site_name":"Alistar","article_published_time":"2022-09-28T13:07:00+00:00","article_modified_time":"2026-10-02T11:42:11+00:00","og_image":[{"width":2560,"height":1610,"url":"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp","type":"image\/webp"}],"author":"Shardae Castelen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shardae Castelen","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#article","isPartOf":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/"},"author":{"name":"Shardae Castelen","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50"},"headline":"Performance tuning van Power BI dashboards","datePublished":"2022-09-28T13:07:00+00:00","dateModified":"2026-10-02T11:42:11+00:00","mainEntityOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/"},"wordCount":631,"publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp","keywords":["Power BI"],"articleSection":["Blog NL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/","url":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/","name":"Performance Tuning for Power BI Dashboards - Alistar","isPartOf":{"@id":"https:\/\/alistar.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#primaryimage"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp","datePublished":"2022-09-28T13:07:00+00:00","dateModified":"2026-10-02T11:42:11+00:00","breadcrumb":{"@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#primaryimage","url":"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2022\/09\/shutterstock_2633166915-scaled.webp","width":2560,"height":1610},{"@type":"BreadcrumbList","@id":"https:\/\/alistar.net\/en\/blog\/performance-tuning-van-power-bi-dashboards\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/alistar.net\/"},{"@type":"ListItem","position":2,"name":"Performance tuning van Power BI dashboards"}]},{"@type":"WebSite","@id":"https:\/\/alistar.net\/en\/#website","url":"https:\/\/alistar.net\/en\/","name":"Alistar","description":"","publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/alistar.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/alistar.net\/en\/#organization","name":"Alistar","url":"https:\/\/alistar.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","width":260,"height":260,"caption":"Alistar"},"image":{"@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/alistar\/"]},{"@type":"Person","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50","name":"Shardae Castelen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","caption":"Shardae Castelen"}}]}},"_links":{"self":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/comments?post=26962"}],"version-history":[{"count":1,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26962\/revisions"}],"predecessor-version":[{"id":75906,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26962\/revisions\/75906"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media\/28551"}],"wp:attachment":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media?parent=26962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/categories?post=26962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/tags?post=26962"},{"taxonomy":"industrie-type","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/industrie-type?post=26962"},{"taxonomy":"interesses","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/interesses?post=26962"},{"taxonomy":"techologie","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/techologie?post=26962"},{"taxonomy":"alistar_language","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/alistar_language?post=26962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}