{"id":1897,"date":"2019-07-07T04:23:47","date_gmt":"2019-07-07T04:23:47","guid":{"rendered":"https:\/\/nub8.net\/?p=1897"},"modified":"2026-04-08T14:06:51","modified_gmt":"2026-04-08T14:06:51","slug":"power-bi-architecture-performance-improvements","status":"publish","type":"post","link":"https:\/\/nub8.net\/es\/power-bi-architecture-performance-improvements\/","title":{"rendered":"Power BI Architecture &#8211; Performance Improvements"},"content":{"rendered":"<p>PowerBI Consultant must start with the end in mind and ensure all reports answer precise business questions that empower you to make intelligent business decisions.<\/p>\n<p><img decoding=\"async\" class=\"size-medium wp-image-7573 aligncenter\" src=\"https:\/\/nub8.net\/wp-content\/uploads\/2019\/07\/power-bi-min-300x150.png\" alt=\"\" width=\"300\" height=\"150\" \/><\/p>\n<p>Following are some of the tips to improve the performance in Power BI implementation.<\/p>\n<p>\u2022 For Power BI, try to create <strong>calculated measures<\/strong> instead of <strong>calculated columns<\/strong>. Move calculated columns and measures to the data source wherever possible. The nearer they are to the source, the greater the likelihood of better performance.<\/p>\n<p>\u2022 <strong>Slicers<\/strong> are an excessively important way of allowing users to navigate data, but they cause at a performance overhead. Each slicer makes two queries: one acquires the data, and the other gets selection details. Making too many slicers influences performance negatively.<\/p>\n<p>\u2022 In Power BI, if we place so <strong>many visuals<\/strong> on the solo page, it will slow down the performance of dashboard. We suggest using a maximum of eight visuals per page. Occasionally, based on prerequisite we need to increase more visual on the page, at that time we need to arrange and choose visualization intelligently.<\/p>\n<p>\u2022 For Power BI solution, if the same data gateway is utilized for <strong>Scheduled Data Refresh<\/strong> and <strong>Live Connection<\/strong>, Live Connection performance will be see deceased performance when Scheduled Data Refresh is active. Avoid this matter by building separate data gateways for Live Connection and Scheduled Refresh.<\/p>\n<p>\u2022 In Power BI, <strong>Integers behave much faster than strings<\/strong>. Since strings are kept in a hash table, they are efficiently referenced twice, once for the hash value and once to get the string associated with that value. Changing string to a predictable integer that is incremented for every row lets columnar storage to compress this column and the hash table reference is not required.<\/p>\n<p>\u2022 In Power BI, prefer to pull <strong>data from views, not tables<\/strong>. Importing data from tables in a SQL Server makes strong dependencies between the physical data model and the reporting engine. When table structures modify, it\u2019s best to tweak relational data from views.<\/p>\n<p>What differentiates <a href=\"https:\/\/nub8.net\/es\/services\/\">Nub8 <\/a>is our deep knowledge of data combined with unparalleled depth of skill in Power BI customization. Our tailor-made Power BI solutions straightforwardly allow you to visually discover your data and ask specific business questions that drive profitability. We provide our clients complete BI solutions that create a full picture of corporate resourcefulness and increase decision making. Our experienced team of Power BI consultants take great joy in guaranteeing that the simply, still smart BI.<\/p>","protected":false},"excerpt":{"rendered":"<p>PowerBI Consultant must start with the end in mind and ensure all reports answer precise business questions that empower you to make intelligent business decisions. Following are some of the tips to improve the performance in Power BI implementation. \u2022 For Power BI, try to create calculated measures instead of calculated columns. Move calculated columns [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7573,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,31],"tags":[],"class_list":["post-1897","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-big-data"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/posts\/1897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/comments?post=1897"}],"version-history":[{"count":1,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/posts\/1897\/revisions"}],"predecessor-version":[{"id":11947,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/posts\/1897\/revisions\/11947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nub8.net\/es\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/media?parent=1897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/categories?post=1897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nub8.net\/es\/wp-json\/wp\/v2\/tags?post=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}