{"id":258,"date":"2025-12-02T20:58:25","date_gmt":"2025-12-02T20:58:25","guid":{"rendered":"https:\/\/www.qbi.dk\/?p=258"},"modified":"2025-12-02T21:05:10","modified_gmt":"2025-12-02T21:05:10","slug":"direct-query","status":"publish","type":"post","link":"https:\/\/www.qbi.dk\/?p=258","title":{"rendered":"DirectQuery i Power BI: Hvorn\u00e5r og hvorfor du b\u00f8r overveje det"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"258\" class=\"elementor elementor-258\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-43a85d8 e-flex e-con-boxed e-con e-parent\" data-id=\"43a85d8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-977a9ed elementor-widget elementor-widget-text-editor\" data-id=\"977a9ed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>N\u00e5r du bygger BI-l\u00f8sninger, er valget af dataforbindelses-metode centralt. DirectQuery er en af de vigtigste \u2014 og kan i mange situationer v\u00e6re et godt valg.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-69e9608 e-flex e-con-boxed e-con e-parent\" data-id=\"69e9608\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-df35576 elementor-widget elementor-widget-heading\" data-id=\"df35576\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Hvad er DirectQuery?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8ed8e2b elementor-widget elementor-widget-text-editor\" data-id=\"8ed8e2b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li data-start=\"370\" data-end=\"628\"><p data-start=\"372\" data-end=\"628\">DirectQuery betyder, at Power BI ikke importerer data til selve modellen \u2014 i stedet forbliver data i kilden, og hver gang du \u00e5bner eller opdaterer et dashboard, bliver der sendt en foresp\u00f8rgsel direkte mod databasen.\u00a0<\/p><\/li><li data-start=\"629\" data-end=\"806\"><p data-start=\"631\" data-end=\"806\">Det betyder ogs\u00e5, at dit dashboard altid viser de nyeste data \u2014 perfekt hvis data \u00e6ndres ofte, eller du har brug for real-time indsigt.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f9f1cb elementor-widget elementor-widget-heading\" data-id=\"9f9f1cb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Hvorn\u00e5r giver DirectQuery mening?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-490a151 elementor-widget elementor-widget-text-editor\" data-id=\"490a151\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li data-start=\"875\" data-end=\"1072\"><p data-start=\"877\" data-end=\"1072\">Du har store datam\u00e6ngder \u2014 s\u00e5 store at det ikke er hensigtsm\u00e6ssigt at importere dem ind i Power BI. DirectQuery omg\u00e5r datamodel-st\u00f8rrelses-begr\u00e6nsningerne.<\/p><\/li><li data-start=\"875\" data-end=\"1072\"><p data-start=\"877\" data-end=\"1072\">Du har brug for, at dashboards altid viser opdaterede data \u2014 fx salgstal, lagerstatus, real-time logdata etc.<\/p><\/li><li data-start=\"1225\" data-end=\"1354\"><p data-start=\"1227\" data-end=\"1354\">Du \u00f8nsker at reducere datakopiering og undg\u00e5 dataduplication \u2014 data forbliver i kilden.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-771aa67 elementor-widget elementor-widget-heading\" data-id=\"771aa67\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Ulemper &amp; overvejelser<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d063836 elementor-widget elementor-widget-text-editor\" data-id=\"d063836\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"1389\" data-end=\"1438\">Der er dog trade-offs ved at bruge DirectQuery:<\/p><ul data-start=\"1440\" data-end=\"1976\"><li data-start=\"1440\" data-end=\"1658\"><p data-start=\"1442\" data-end=\"1658\">Performance afh\u00e6nger af datakilden: hver visualisering udl\u00f8ser foresp\u00f8rgsler mod databasen \u2014 hvis kilden er langsom, eller brugere mange, kan det give langsom rapportoplevelse.<\/p><\/li><li data-start=\"1659\" data-end=\"1832\"><p data-start=\"1661\" data-end=\"1832\">Nogle funktionaliteter i Power BI (eller transformationer via Power Query) er begr\u00e6nsede eller ikke underst\u00f8ttet under DirectQuery.\u00a0<\/p><\/li><li data-start=\"1833\" data-end=\"1976\"><p data-start=\"1835\" data-end=\"1976\">Der kan v\u00e6re begr\u00e6nsninger i antal r\u00e6kker, som kan returneres i visninger, is\u00e6r ved cloud-datakilder.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e204fb elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"7e204fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d52d38 elementor-widget elementor-widget-heading\" data-id=\"4d52d38\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Mine anbefalinger:<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3def2a elementor-widget elementor-widget-text-editor\" data-id=\"a3def2a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul><li data-start=\"2067\" data-end=\"2211\"><p data-start=\"2069\" data-end=\"2211\">Vurderer om datam\u00e6ngde og opdaterings-behov retf\u00e6rdigg\u00f8r DirectQuery \u2014 ofte giver det mening n\u00e5r datagrundlaget er stort eller dynamisk.<\/p><\/li><li data-start=\"2212\" data-end=\"2399\"><p data-start=\"2214\" data-end=\"2399\">Kombinerer DirectQuery med \u201cimport mode\u201d i en sammensat model: fx store fakta-tabeller via DirectQuery, mindre dimensionstabeller importeret for performance og fleksibilitet.<\/p><\/li><li data-start=\"2400\" data-end=\"2571\"><p data-start=\"2402\" data-end=\"2571\">S\u00f8rger for at datakilden er optimeret (indekser, views, pre-aggregeringer) s\u00e5 foresp\u00f8rgsler bliver s\u00e5 hurtige som muligt, og brugererfaringen forbliver acceptabel.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>N\u00e5r du bygger BI-l\u00f8sninger, er valget af dataforbindelses-metode centralt. DirectQuery er en af de vigtigste \u2014 og kan i mange situationer v\u00e6re et godt valg. Hvad er DirectQuery? DirectQuery betyder, at Power BI ikke importerer data til selve modellen \u2014 i stedet forbliver data i kilden, og hver gang du \u00e5bner eller opdaterer et dashboard, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[20,21],"class_list":["post-258","post","type-post","status-publish","format-standard","hentry","category-data","tag-direct-query","tag-optimering"],"_links":{"self":[{"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/posts\/258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=258"}],"version-history":[{"count":8,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions"}],"predecessor-version":[{"id":266,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions\/266"}],"wp:attachment":[{"href":"https:\/\/www.qbi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbi.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}