{"id":4672,"date":"2025-09-16T12:39:47","date_gmt":"2025-09-16T11:39:47","guid":{"rendered":"https:\/\/data4success.de\/?p=4672"},"modified":"2025-11-27T08:05:11","modified_gmt":"2025-11-27T07:05:11","slug":"dataverse-in-microsoft-fabric-data-integration-via-shortcuts","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/dataverse-in-microsoft-fabric-data-integration-via-shortcuts\/","title":{"rendered":"Dataverse in Microsoft Fabric: data integration via shortcuts"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"4672\" class=\"elementor elementor-4672\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ddb5600 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ddb5600\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7a9e52d\" data-id=\"7a9e52d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-907af0f elementor-widget elementor-widget-text-editor\" data-id=\"907af0f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"327\" data-end=\"674\">Die Integration von Gesch\u00e4ftsdaten aus <strong data-start=\"366\" data-end=\"392\">Microsoft Dynamics NAV<\/strong>, <strong data-start=\"394\" data-end=\"406\">Navision<\/strong> und <strong data-start=\"411\" data-end=\"431\">Business Central<\/strong> in moderne Analyseplattformen ist seit Jahren ein zentrales Thema. Viele Unternehmen m\u00f6chten ihre operativen Systeme (ERP, CRM) mit Analytics, Machine Learning oder Self-Service BI verbinden \u2013 ohne dabei unn\u00f6tige Kopien der Daten anzulegen.<\/p><p data-start=\"676\" data-end=\"903\">Mit <strong data-start=\"680\" data-end=\"700\">Microsoft Fabric<\/strong> und der Funktion <strong data-start=\"718\" data-end=\"731\">Shortcuts<\/strong> bietet Microsoft eine leistungsstarke M\u00f6glichkeit, Daten aus dem <strong data-start=\"797\" data-end=\"810\">Dataverse<\/strong> direkt in das Lakehouse einzubinden \u2013 schnell, effizient und ohne redundante Datenhaltung.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-526690c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"526690c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3f653b7\" data-id=\"3f653b7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-89ec855 elementor-widget elementor-widget-text-editor\" data-id=\"89ec855\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"910\" data-end=\"931\">Was ist Dataverse?<\/h3><p data-start=\"932\" data-end=\"1210\"><strong data-start=\"932\" data-end=\"945\">Dataverse<\/strong> ist die zugrundeliegende Datenplattform von Microsoft, die Daten aus verschiedenen Business-Anwendungen wie <strong data-start=\"1054\" data-end=\"1070\">Dynamics 365<\/strong>, <strong data-start=\"1072\" data-end=\"1086\">Power Apps<\/strong> oder <strong data-start=\"1092\" data-end=\"1113\">Customer Insights<\/strong> verwaltet.<br data-start=\"1124\" data-end=\"1127\" \/>Es stellt sicher, dass Daten zentral, strukturiert und sicher gespeichert werden.<\/p><p data-start=\"1212\" data-end=\"1475\">F\u00fcr Unternehmen, die <strong data-start=\"1233\" data-end=\"1249\">Dynamics NAV<\/strong>, <strong data-start=\"1251\" data-end=\"1263\">Navision<\/strong> oder die modernere L\u00f6sung <strong data-start=\"1290\" data-end=\"1310\">Business Central<\/strong> einsetzen, ist Dataverse ein wichtiger Baustein, um Gesch\u00e4ftsdaten f\u00fcr Analysen bereitzustellen \u2013 von Kundendaten bis zu Transaktions- und Marketinginformationen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72efbb1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72efbb1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-84f0137\" data-id=\"84f0137\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-38c4b2e elementor-widget elementor-widget-text-editor\" data-id=\"38c4b2e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"1482\" data-end=\"1535\">Shortcuts in Fabric: Der Schl\u00fcssel zur Integration<\/h3><p data-start=\"1536\" data-end=\"1688\">Die <strong data-start=\"1540\" data-end=\"1561\">Shortcut-Funktion<\/strong> in Microsoft Fabric erm\u00f6glicht es, externe Datenquellen wie Dataverse <strong data-start=\"1632\" data-end=\"1656\">ohne physische Kopie<\/strong> in das Lakehouse einzubinden.<\/p><h3 data-start=\"1690\" data-end=\"1703\">Vorteile:<\/h3><ul data-start=\"1704\" data-end=\"2091\"><li data-start=\"1704\" data-end=\"1785\"><p data-start=\"1706\" data-end=\"1785\"><strong data-start=\"1706\" data-end=\"1725\">Keine Duplikate<\/strong>: Daten werden nicht dupliziert, sondern nur referenziert.<\/p><\/li><li data-start=\"1786\" data-end=\"1888\"><p data-start=\"1788\" data-end=\"1888\"><strong data-start=\"1788\" data-end=\"1812\">Nahtlose Integration<\/strong>: Tabellen erscheinen im Lakehouse-Schema, als w\u00e4ren sie dort gespeichert.<\/p><\/li><li data-start=\"1889\" data-end=\"1998\"><p data-start=\"1891\" data-end=\"1998\"><strong data-start=\"1891\" data-end=\"1905\">Aktualit\u00e4t<\/strong>: Daten sind nahezu in Echtzeit zug\u00e4nglich \u2013 \u00c4nderungen im Dataverse sind direkt verf\u00fcgbar.<\/p><\/li><li data-start=\"1999\" data-end=\"2091\"><p data-start=\"2001\" data-end=\"2091\"><strong data-start=\"2001\" data-end=\"2020\">Kostenersparnis<\/strong>: Weniger Speicherbedarf, da keine redundanten Kopien erzeugt werden.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c606484 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c606484\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f9f227d\" data-id=\"f9f227d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-32e1cd1 elementor-widget elementor-widget-text-editor\" data-id=\"32e1cd1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"2098\" data-end=\"2163\">Typisches Szenario: Dynamics NAV \/ Navision \/ Business Central<\/h3><p data-start=\"2164\" data-end=\"2335\">Viele Unternehmen, die von Microsoft Dynamics NAV (Navision) auf Business Central migriert sind, nutzen Dataverse als Integrationsschicht f\u00fcr CRM- und ERP-Daten.<\/p><p data-start=\"2337\" data-end=\"2349\">Beispiele:<\/p><ul data-start=\"2350\" data-end=\"2694\"><li data-start=\"2350\" data-end=\"2463\"><p data-start=\"2352\" data-end=\"2463\"><strong data-start=\"2352\" data-end=\"2377\">Finance &amp; Controlling<\/strong>: Auftragsdaten aus Business Central stehen im Fabric Lakehouse f\u00fcr Power BI bereit.<\/p><\/li><li data-start=\"2464\" data-end=\"2584\"><p data-start=\"2466\" data-end=\"2584\"><strong data-start=\"2466\" data-end=\"2487\">Marketing &amp; Sales<\/strong>: Customer Journeys aus Dataverse k\u00f6nnen mit Umsatzdaten aus Business Central verkn\u00fcpft werden.<\/p><\/li><li data-start=\"2585\" data-end=\"2694\"><p data-start=\"2587\" data-end=\"2694\"><strong data-start=\"2587\" data-end=\"2609\">Prozessoptimierung<\/strong>: Daten aus ERP (Navision\/NAV\/BC) und CRM (Dataverse) werden gemeinsam ausgewertet.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c4dc2d7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4dc2d7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-18969e9\" data-id=\"18969e9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-48817ae elementor-widget elementor-widget-text-editor\" data-id=\"48817ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"2701\" data-end=\"2734\">Technische Umsetzung in Fabric<\/h3><ol data-start=\"2735\" data-end=\"3232\"><li data-start=\"2735\" data-end=\"2839\"><p data-start=\"2738\" data-end=\"2839\"><strong data-start=\"2738\" data-end=\"2760\">Connection anlegen<\/strong>: Verbindung zu Dataverse-Umgebung (z. B. <code data-start=\"2802\" data-end=\"2835\">marketing.crm4.dynamics.com<\/code>).<\/p><\/li><li data-start=\"2840\" data-end=\"2969\"><p data-start=\"2843\" data-end=\"2915\"><strong data-start=\"2843\" data-end=\"2865\">Shortcut erstellen<\/strong>: Tabelle aus Dataverse ins Lakehouse einbinden.<\/p><ul data-start=\"2919\" data-end=\"2969\"><li data-start=\"2919\" data-end=\"2969\"><p data-start=\"2921\" data-end=\"2969\">Beispiel: <code data-start=\"2931\" data-end=\"2967\">[lakehouse].[cij].[contact]<\/code><\/p><\/li><\/ul><\/li><li data-start=\"2970\" data-end=\"3151\"><p data-start=\"2973\" data-end=\"2993\"><strong data-start=\"2973\" data-end=\"2990\">Schema-Design<\/strong>:<\/p><ul data-start=\"2997\" data-end=\"3151\"><li data-start=\"2997\" data-end=\"3029\"><p data-start=\"2999\" data-end=\"3029\">Bronze: Rohdaten (Shortcut).<\/p><\/li><li data-start=\"3033\" data-end=\"3094\"><p data-start=\"3035\" data-end=\"3094\">Silver: Standardisierte Views (vereinheitlichte Spalten).<\/p><\/li><li data-start=\"3098\" data-end=\"3151\"><p data-start=\"3100\" data-end=\"3151\">Gold: Business-orientierte Sichten f\u00fcr Reporting.<\/p><\/li><\/ul><\/li><li data-start=\"3152\" data-end=\"3232\"><p data-start=\"3155\" data-end=\"3232\"><strong data-start=\"3155\" data-end=\"3166\">Analyse<\/strong>: Power BI oder Machine Learning greift direkt auf die Daten zu.<\/p><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-47dbf20 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"47dbf20\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0d076f2\" data-id=\"0d076f2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f3548b2 elementor-widget elementor-widget-text-editor\" data-id=\"f3548b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"3239\" data-end=\"3256\">Best Practices<\/h3><ul data-start=\"3257\" data-end=\"3719\"><li data-start=\"3257\" data-end=\"3338\"><p data-start=\"3259\" data-end=\"3338\"><strong>Namenskonventionen einhalten<\/strong>: z. B. <code data-start=\"3299\" data-end=\"3335\">[bronze].[DataverseSchema].[Table]<\/code>.<\/p><\/li><li data-start=\"3339\" data-end=\"3466\"><p data-start=\"3341\" data-end=\"3466\"><strong data-start=\"3341\" data-end=\"3365\">Performance beachten<\/strong>: Shortcuts sind referenzierte Daten \u2013 f\u00fcr intensive Berechnungen ggf. Silver\/Gold-Layer verwenden.<\/p><\/li><li data-start=\"3467\" data-end=\"3579\"><p data-start=\"3469\" data-end=\"3579\"><strong data-start=\"3469\" data-end=\"3494\">Security &amp; Governance<\/strong>: Dataverse-Rechte gelten auch in Fabric \u2013 Zugriff nur mit g\u00fcltigen Berechtigungen.<\/p><\/li><li data-start=\"3580\" data-end=\"3719\"><p data-start=\"3582\" data-end=\"3719\"><strong data-start=\"3582\" data-end=\"3620\">Kombination mit historischen Daten<\/strong>: Business Central h\u00e4lt oft nur begrenzte Historie; durch Fabric lassen sich Daten historisieren.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a3a7566 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a3a7566\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6063aaa\" data-id=\"6063aaa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c1e6cd4 elementor-widget elementor-widget-text-editor\" data-id=\"c1e6cd4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"3726\" data-end=\"3734\">Mit <strong data-start=\"3739\" data-end=\"3769\">Microsoft Fabric Shortcuts<\/strong> wird die Integration von <strong data-start=\"3795\" data-end=\"3808\">Dataverse<\/strong>-Daten aus <strong data-start=\"3819\" data-end=\"3856\">Microsoft Dynamics NAV (Navision)<\/strong> und <strong data-start=\"3861\" data-end=\"3881\">Business Central<\/strong> erheblich vereinfacht.<\/p><p data-start=\"3735\" data-end=\"4055\">Unternehmen k\u00f6nnen so operative Daten in Echtzeit f\u00fcr Analytics, BI und KI nutzen \u2013 ohne aufwendige ETL-Prozesse oder redundante Datenhaltung.<\/p><p data-start=\"4057\" data-end=\"4191\">Das Ergebnis: <strong data-start=\"4071\" data-end=\"4145\">schnellere Analysen, geringere Kosten und eine einheitliche Datenbasis<\/strong> f\u00fcr Marketing, Vertrieb, Finanzen und mehr.<\/p><p data-start=\"4057\" data-end=\"4191\"><strong>Haben Sie noch Fragen oder m\u00f6chten Sie mehr \u00fcber unsere Methoden erfahren?<\/strong> <a href=\"https:\/\/data4success.de\/kontakt\/\">Kontaktieren Sie uns<\/a> \u2013 wir zeigen Ihnen, wie Sie Ihre Daten f\u00fcr nachhaltigen Erfolg nutzen k\u00f6nnen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Die Integration von Gesch\u00e4ftsdaten aus Microsoft Dynamics NAV, Navision und Business Central in moderne Analyseplattformen ist seit Jahren ein zentrales Thema. Viele Unternehmen m\u00f6chten ihre operativen Systeme (ERP, CRM) mit Analytics, Machine Learning oder Self-Service BI verbinden \u2013 ohne dabei unn\u00f6tige Kopien der Daten anzulegen. Mit Microsoft Fabric und der Funktion Shortcuts bietet Microsoft eine [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4683,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4672","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=4672"}],"version-history":[{"count":10,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4672\/revisions"}],"predecessor-version":[{"id":4774,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4672\/revisions\/4774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/4683"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=4672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=4672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=4672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}