{"id":1652,"date":"2026-11-17T16:28:14","date_gmt":"2026-11-17T14:28:14","guid":{"rendered":"https:\/\/www.kaarne.fi\/superstore\/?p=1652"},"modified":"2026-11-17T16:28:14","modified_gmt":"2026-11-17T14:28:14","slug":"power-bi-duplicate-daily-rows","status":"publish","type":"post","link":"https:\/\/www.kaarne.fi\/superstore\/articles\/power-bi-duplicate-daily-rows\/","title":{"rendered":"Your Chart Looks Fine. Did the Data Load Twice?"},"content":{"rendered":"<p>The chart has the right shape. Monday is busier than Tuesday and the channels appear in the expected order. Nothing looks obviously wrong.<\/p>\n<p>Then an independent check finds that the source data were included twice. A familiar pattern survived while every affected count grew. Visual plausibility was never a sufficient control.<\/p>\n<h2>Define one row before counting rows<\/h2>\n<p>Imagine a fictional report built from daily service totals. One row represents one date and one channel. That combination is the intended key for this exercise; it is not a list of individual customer cases.<\/p>\n<p>Write down the expected grain before importing or combining files. A repeated date may be normal because several channels report on that day. A repeated date-channel combination needs investigation under this particular rule.<\/p>\n<p>A duplicate check must reflect the source\u2019s actual meaning. Do not remove rows simply because several values happen to match. Two legitimately different observations can contain identical numbers.<\/p>\n<h2>Keep an independent control<\/h2>\n<p>Record an expected row count and a few totals from the approved fictional source. Compare them after loading and after any transformation that could change the structure.<\/p>\n<p>Use a control that is independent of the same transformation being tested. Two visuals built from the same duplicated table can agree perfectly while repeating the same mistake.<\/p>\n<p>Check both the number of records and their values. A correct row count does not prove every record is the right one, and a matching total can occasionally conceal offsetting errors.<\/p>\n<h2>Review combinations and relationships<\/h2>\n<p>Combining files or attaching descriptive information can change a dataset unexpectedly when keys are not unique. Inspect unmatched and repeated keys before relying on the joined result.<\/p>\n<p>Microsoft\u2019s star-schema guidance emphasises a consistent grain for fact data. That principle is useful even in a modest learning project: know what observation each row represents, then make the model preserve it.<\/p>\n<p>For a daily-channel exercise, use deliberately distinct test values. They make a duplicated contribution easier to trace than a table full of similar figures.<\/p>\n<h2>Keep the exception visible until it is explained<\/h2>\n<p>When a repeated key appears, record where it came from and whether it is a source duplicate, an import problem or a legitimate change to the data structure. Correct the cause rather than hiding the symptom in the chart.<\/p>\n<p>After the correction, rerun the row-count and value checks and record the observed results. Keep any unresolved question in the validation note.<\/p>\n<p>The goal is an explainable report, not a chart that happens to look familiar. A small control table can protect that explanation better than an hour spent adjusting colours.<\/p>\n<h2>Continue with a related question<\/h2>\n<p>Explore <a href=\"https:\/\/www.kaarne.fi\/superstore\/power-bi-report-validation-handover\/\">Build a Power BI Report You Can Check and Hand Over<\/a>, or read <a href=\"https:\/\/www.kaarne.fi\/superstore\/articles\/power-bi-refresh-handover\/\">The Report Opens. Can Someone Else Refresh It Next Month?<\/a>.<\/p>\n<p>For a written practice option, see <a href=\"https:\/\/www.kaarne.fi\/superstore\/power-bi-with-matze\/\">Power BI with Matze: contents and requirements<\/a>.<\/p>\n<p><a href=\"https:\/\/einfachmitmatze.de\/power-bi-service-dashboard\/#aff=pasi5e9a&amp;cam=superstore-editorial-20261117\" rel=\"sponsored noopener\" target=\"_blank\">Review the provider\u2019s course details<\/a>. Affiliate link: Superstore may earn a commission if you buy.<\/p>\n<p>Technical reference: <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/guidance\/star-schema\" target=\"_blank\" rel=\"noopener\">Microsoft Learn: Power BI model design<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A chart can look plausible with duplicated data. Define the daily-channel key and reconcile row counts and totals before trusting a new Power BI report.<\/p>\n","protected":false},"author":1,"featured_media":1692,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[35],"tags":[],"class_list":["post-1652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-digital-tools"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/www.kaarne.fi\/superstore\/wp-content\/uploads\/sites\/7\/2026\/11\/power-bi-8.webp","_links":{"self":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/comments?post=1652"}],"version-history":[{"count":5,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1652\/revisions"}],"predecessor-version":[{"id":1837,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/posts\/1652\/revisions\/1837"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media\/1692"}],"wp:attachment":[{"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/media?parent=1652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/categories?post=1652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaarne.fi\/superstore\/wp-json\/wp\/v2\/tags?post=1652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}