{"id":4725,"date":"2025-11-24T10:00:50","date_gmt":"2025-11-24T09:00:50","guid":{"rendered":"https:\/\/data4success.de\/?p=4725"},"modified":"2025-11-27T08:10:21","modified_gmt":"2025-11-27T07:10:21","slug":"dataflow-gen2-in-microsoft-fabric-self-service-data-integration-for-the-midmarket","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/dataflow-gen2-in-microsoft-fabric-self-service-data-integration-for-the-midmarket\/","title":{"rendered":"Dataflow Gen2 in Microsoft Fabric - self-service data integration for SMEs"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4725\" class=\"elementor elementor-4725\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0f4f07c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f4f07c\" 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-b5382ef\" data-id=\"b5382ef\" 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-6672ab6 elementor-widget elementor-widget-text-editor\" data-id=\"6672ab6\" 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=\"396\" data-end=\"736\">Many companies in the SME sector use different systems: <strong data-start=\"462\" data-end=\"512\">ERP (Dynamics NAV, Navision, Business Central)<\/strong>, CRM, Excel lists, cloud services or production systems. The challenge: integrating all these data sources into one <strong data-start=\"625\" data-end=\"652\">Standardized database<\/strong> without having to set up a complex IT solution for every requirement.<\/p><p data-start=\"738\" data-end=\"798\">This is exactly where <strong data-start=\"755\" data-end=\"792\">Dataflow Gen2 in Microsoft Fabric<\/strong> to.<\/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-5c8994b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c8994b\" 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-aa904b4\" data-id=\"aa904b4\" 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-7e27249 elementor-widget elementor-widget-text-editor\" data-id=\"7e27249\" 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=\"800\" data-end=\"827\">What is Dataflow Gen2?<\/h3><p data-start=\"828\" data-end=\"1097\">Dataflow Gen2 is a further development of the well-known Power BI Dataflows - but integrated into the entire <strong data-start=\"941\" data-end=\"961\">Fabric platform<\/strong>. With a <strong data-start=\"973\" data-end=\"998\">graphical user interface<\/strong> data sources can be connected, transformed and cleansed - without the need for complex ETL tools.<\/p><p data-start=\"1099\" data-end=\"1118\">The special feature:<\/p><ul data-start=\"1119\" data-end=\"1320\"><li data-start=\"1119\" data-end=\"1170\"><p data-start=\"1121\" data-end=\"1170\">Data is transferred directly to <strong data-start=\"1144\" data-end=\"1155\">OneLake<\/strong> saved.<\/p><\/li><li data-start=\"1171\" data-end=\"1226\"><p data-start=\"1173\" data-end=\"1226\">Transformations can <strong data-start=\"1197\" data-end=\"1216\">reused<\/strong> become.<\/p><\/li><li data-start=\"1227\" data-end=\"1320\"><p data-start=\"1229\" data-end=\"1320\">Data is immediately available to all fabric workloads (Lakehouse, Warehouse, Reports).<\/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-8ff528a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ff528a\" 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-1b8e097\" data-id=\"1b8e097\" 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-5d0f494 elementor-widget elementor-widget-text-editor\" data-id=\"5d0f494\" 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=\"187\" data-end=\"226\">How does Dataflow Gen2 work?<\/h3><p data-start=\"227\" data-end=\"344\">Dataflow Gen2 is basically a <strong data-start=\"260\" data-end=\"285\">Self-service ETL tool<\/strong>, which is completely <strong data-start=\"306\" data-end=\"326\">Microsoft Fabric<\/strong> is integrated.<\/p><ul data-start=\"345\" data-end=\"706\"><li data-start=\"345\" data-end=\"412\"><p data-start=\"347\" data-end=\"412\"><strong data-start=\"347\" data-end=\"352\">E<\/strong>xtract: Data from various sources is connected.<\/p><\/li><li data-start=\"413\" data-end=\"544\"><p data-start=\"415\" data-end=\"544\"><strong data-start=\"415\" data-end=\"420\">T<\/strong>ransform: Via a <strong data-start=\"440\" data-end=\"476\">Graphical Power Query interface<\/strong> data can be cleansed, transformed and merged.<\/p><\/li><li data-start=\"545\" data-end=\"706\"><p data-start=\"547\" data-end=\"706\"><strong data-start=\"547\" data-end=\"552\">L<\/strong>oad: Results are automatically saved in <strong data-start=\"590\" data-end=\"601\">OneLake<\/strong> and are immediately available to all fabric workloads (Lakehouse, Warehouse, Power BI).<\/p><\/li><\/ul><p data-start=\"708\" data-end=\"831\">The highlight: Dataflows are <strong data-start=\"735\" data-end=\"757\">defined once<\/strong> and can be executed again and again - manually or time-controlled.<\/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-2dfa281 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2dfa281\" 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-098d2c1\" data-id=\"098d2c1\" 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-ad3bfe6 elementor-widget elementor-widget-text-editor\" data-id=\"ad3bfe6\" 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=\"1322\" data-end=\"1389\">Why is this exciting for NAV, Navision and Business Central?<\/h3><p data-start=\"1390\" data-end=\"1445\">The following problems often arise with ERP data in particular:<\/p><ul data-start=\"1446\" data-end=\"1660\"><li data-start=\"1446\" data-end=\"1520\"><p data-start=\"1448\" data-end=\"1520\">Different tables must be merged for reporting.<\/p><\/li><li data-start=\"1521\" data-end=\"1574\"><p data-start=\"1523\" data-end=\"1574\">Excel exports must be cleaned up regularly.<\/p><\/li><li data-start=\"1575\" data-end=\"1660\"><p data-start=\"1577\" data-end=\"1660\">Changes in the ERP mean that reports have to be adapted again and again.<\/p><\/li><\/ul><p data-start=\"1662\" data-end=\"1730\">With Dataflow Gen2, specialist departments can define their own rules:<\/p><ul data-start=\"1731\" data-end=\"1958\"><li data-start=\"1731\" data-end=\"1805\"><p data-start=\"1733\" data-end=\"1805\"><strong data-start=\"1733\" data-end=\"1756\">Joining tables<\/strong> (e.g. sales orders with customer master data).<\/p><\/li><li data-start=\"1806\" data-end=\"1899\"><p data-start=\"1808\" data-end=\"1899\"><strong data-start=\"1808\" data-end=\"1838\">Transformation of fields<\/strong> (e.g. converting currencies or formatting date fields).<\/p><\/li><li data-start=\"1900\" data-end=\"1958\"><p data-start=\"1902\" data-end=\"1958\"><strong data-start=\"1902\" data-end=\"1927\">Data cleansing<\/strong> (e.g. remove duplicates).<\/p><\/li><\/ul><p data-start=\"1960\" data-end=\"2034\">This relieves the IT department and speeds up reporting.<\/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-80fe3dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"80fe3dd\" 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-a32e0d4\" data-id=\"a32e0d4\" 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-ae253a4 elementor-widget elementor-widget-text-editor\" data-id=\"ae253a4\" 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=\"2036\" data-end=\"2065\">Advantages at a glance<\/h3><ul data-start=\"2066\" data-end=\"2342\"><li data-start=\"2066\" data-end=\"2137\"><p data-start=\"2068\" data-end=\"2137\"><strong data-start=\"2068\" data-end=\"2084\">Self-service<\/strong>Departments can create data flows themselves.<\/p><\/li><li data-start=\"2138\" data-end=\"2208\"><p data-start=\"2140\" data-end=\"2208\"><strong data-start=\"2140\" data-end=\"2164\">Central storage<\/strong>Data is stored directly in OneLake.<\/p><\/li><li data-start=\"2209\" data-end=\"2278\"><p data-start=\"2211\" data-end=\"2278\"><strong data-start=\"2211\" data-end=\"2230\">Cost efficiency<\/strong>No need for expensive, separate ETL tools.<\/p><\/li><li data-start=\"2279\" data-end=\"2342\"><p data-start=\"2281\" data-end=\"2342\"><strong data-start=\"2281\" data-end=\"2297\">Flexibility<\/strong>: Easily expandable with new data sources.<\/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-fda5be6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fda5be6\" 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-256d823\" data-id=\"256d823\" 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-d5474c3 elementor-widget elementor-widget-text-editor\" data-id=\"d5474c3\" 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=\"2355\" data-end=\"2445\">With Dataflow Gen2, Microsoft Fabric becomes a real <strong data-start=\"2411\" data-end=\"2442\">Self-service data platform<\/strong>.<\/p><p data-start=\"2447\" data-end=\"2625\">For companies with <strong data-start=\"2467\" data-end=\"2515\">Dynamics NAV, Navision or Business Central<\/strong> This means: less dependence on IT, faster reporting and a <strong data-start=\"2590\" data-end=\"2622\">Central, clean database<\/strong>.<\/p><p data-start=\"2627\" data-end=\"2719\">This makes Dataflow Gen2 the <strong data-start=\"2656\" data-end=\"2716\">The key to efficient data integration in SMEs<\/strong>.<\/p><p data-start=\"2627\" data-end=\"2719\"><strong>Do you have any questions or would you like to find out more about our methods?<\/strong> <a href=\"https:\/\/data4success.de\/en\/contact\/\">Get in touch with us<\/a> - We show you how you can use your data for sustainable success.<\/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>","protected":false},"excerpt":{"rendered":"<p>Viele Unternehmen im Mittelstand nutzen unterschiedliche Systeme: ERP (Dynamics NAV, Navision, Business Central), CRM, Excel-Listen, Cloud-Dienste oder Produktionssysteme. Die Herausforderung: Alle diese Datenquellen in eine einheitliche Datenbasis zu bringen, ohne f\u00fcr jede Anforderung eine komplexe IT-L\u00f6sung aufbauen zu m\u00fcssen. Genau hier setzt Dataflow Gen2 in Microsoft Fabric an. Was ist Dataflow Gen2? Dataflow Gen2 ist [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4734,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4725","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\/4725","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=4725"}],"version-history":[{"count":7,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4725\/revisions"}],"predecessor-version":[{"id":4801,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4725\/revisions\/4801"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/4734"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=4725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=4725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=4725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}