--- title: "#data-integration articles | Hashnode" description: "Explore 117 articles tagged #data-integration on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/data-integration" --- Tag # #data-integration 117 posts · 11 followers [MyData Insights](https://hashnode.com/@mydatainsights) · [Nov 2](https://hashnode.com/posts/composite-models-in-power-bi-combining-sap-d365-and-excel-in-one-report/6ae84a64c9d45d25bd7d7a0d) ### [Composite Models in Power BI: Combining SAP, D365 and Excel in One Report](https://mydatainsights-blogs.hashnode.dev/composite-models-in-power-bi-combining-sap-d365-and-excel-in-one-report?utm_source=hashnode&utm_medium=feed) Power BI composite models for combining SAP, Dynamics 365 and Excel data in one report — how Import and DirectQuery mix, when it. 6 min read · [mydatainsights-blogs.hashnode.dev](https://mydatainsights-blogs.hashnode.dev/composite-models-in-power-bi-combining-sap-d365-and-excel-in-one-report?utm_source=hashnode&utm_medium=feed) [MyData Insights](https://hashnode.com/@mydatainsights) · [Oct 14](https://hashnode.com/posts/common-errors-when-connecting-microsoft-fabric-to-on-premise-sql-server/6acf357a24b2774efc308a87) ### [Common Errors When Connecting Microsoft Fabric to On-Premise SQL Server](https://mydatainsights-blogs.hashnode.dev/common-errors-when-connecting-microsoft-fabric-to-on-premise-sql-server?utm_source=hashnode&utm_medium=feed) Common errors connecting Microsoft Fabric to on-premise SQL Server — the on-premises data gateway, firewall and port issues. 7 min read · [mydatainsights-blogs.hashnode.dev](https://mydatainsights-blogs.hashnode.dev/common-errors-when-connecting-microsoft-fabric-to-on-premise-sql-server?utm_source=hashnode&utm_medium=feed) [Helkyn Coello](https://hashnode.com/@helkyn-coello) · [Sep 21](https://hashnode.com/posts/the-hours-ai-saved-you-have-nowhere-to-go/6ab1ad0eaccd64ab8c99ea30) ### [The hours AI saved you have nowhere to go](https://unlockedconsulting.hashnode.dev/the-hours-ai-saved-you-have-nowhere-to-go?utm_source=hashnode&utm_medium=feed) AI spend doubled while integrated workflows fell from 30% to 16%. Where the saved hours actually go, and the three redesign moves that let them land. 8 min read · [unlockedconsulting.hashnode.dev](https://unlockedconsulting.hashnode.dev/the-hours-ai-saved-you-have-nowhere-to-go?utm_source=hashnode&utm_medium=feed) [Metrica Software](https://hashnode.com/@metrica) · [Sep 4](https://hashnode.com/posts/change-data-capture-for-enterprise-bi-how-cdc-reduces-pipeline-risk/6a9a7bca3e090c9394b464ed) ### [Change Data Capture for Enterprise BI: How CDC Reduces Pipeline Risk](https://metrica.hashnode.dev/change-data-capture-for-enterprise-bi-how-cdc-reduces-pipeline-risk?utm_source=hashnode&utm_medium=feed) Change data capture gives enterprise BI pipelines a precise record of inserts, updates, and deletes without repeatedly copying every source row. That changes the failure surface. A nightly full load c 11 min read · [metrica.hashnode.dev](https://metrica.hashnode.dev/change-data-capture-for-enterprise-bi-how-cdc-reduces-pipeline-risk?utm_source=hashnode&utm_medium=feed) [Andrew Tan](https://hashnode.com/@tandrew) · [Aug 25](https://hashnode.com/posts/the-hidden-costs-of-building-your-own-batch-streaming-integration-layer/6a8d71204c5a4ea5c032686c) ### [The Hidden Costs of Building Your Own Batch-Streaming Integration Layer](https://layline.hashnode.dev/the-hidden-costs-of-building-your-own-batch-streaming-integration-layer?utm_source=hashnode&utm_medium=feed) With AI-assisted coding, building your own data pipelines looks cheaper than ever. But the real costs aren't in the initial build. 8 min read · [layline.hashnode.dev](https://layline.hashnode.dev/the-hidden-costs-of-building-your-own-batch-streaming-integration-layer?utm_source=hashnode&utm_medium=feed) [Andrew Tan](https://hashnode.com/@tandrew) · [Aug 25](https://hashnode.com/posts/the-news-everyone-saw-coming/6a8d5f8ed86dfa51b57472bf) ### [The News Everyone Saw Coming](https://layline.hashnode.dev/the-news-everyone-saw-coming?utm_source=hashnode&utm_medium=feed) Dagster joining Prefect signals the end of standalone orchestrators. The winners will be unified platforms that combine orchestration and processing — and that's exactly where the market is heading. 7 min read · [layline.hashnode.dev](https://layline.hashnode.dev/the-news-everyone-saw-coming?utm_source=hashnode&utm_medium=feed) [MyData Insights](https://hashnode.com/@mydatainsights) · [Aug 14](https://hashnode.com/posts/why-power-bi-refresh-fails-on-large-sap-extracts-timeout-thresholds-root-causes-fixes/6a7ec789700a6d70248c4aaf) ### [Why Power BI Refresh Fails on Large SAP Extracts: Timeout Thresholds, Root Causes & Fixes](https://mydatainsights-blogs.hashnode.dev/why-power-bi-refresh-fails-on-large-sap-extracts-timeout-thresholds-root-causes-fixes?utm_source=hashnode&utm_medium=feed) Power BI refresh failing on large SAP extracts. Explore how 13 min read · [mydatainsights-blogs.hashnode.dev](https://mydatainsights-blogs.hashnode.dev/why-power-bi-refresh-fails-on-large-sap-extracts-timeout-thresholds-root-causes-fixes?utm_source=hashnode&utm_medium=feed) [Andrew Tan](https://hashnode.com/@tandrew) · [Jul 31](https://hashnode.com/posts/your-data-warehouse-is-not-your-data-pipeline/6a6c860d8bcc7e237ed61dad) ### [Your Data Warehouse Is Not Your Data Pipeline](https://layline.hashnode.dev/your-data-warehouse-is-not-your-data-pipeline?utm_source=hashnode&utm_medium=feed) Teams keep forcing their warehouse to do integration work it was never designed for. The result is ballooning costs, opaque failures, and architectures that become harder to maintain the more they ‘succeed.’ 9 min read · [layline.hashnode.dev](https://layline.hashnode.dev/your-data-warehouse-is-not-your-data-pipeline?utm_source=hashnode&utm_medium=feed) [wloadctl](https://hashnode.com/@wloadctl) · [Jul 24](https://hashnode.com/posts/building-an-enterprise-etl-platform-five-challenges-and-architectural-lessons/6a63016cb1330ffb06cca56d) ### [Building an Enterprise ETL Platform: Five Challenges and Architectural Lessons](https://wloadctl.hashnode.dev/building-an-enterprise-etl-platform-five-challenges-and-architectural-lessons?utm_source=hashnode&utm_medium=feed) Digital transformation has become a strategic priority across industries. However, in many enterprise projects, data integration remains one of the most underestimated challenges. Nowadays, enterprise 5 min read · [wloadctl.hashnode.dev](https://wloadctl.hashnode.dev/building-an-enterprise-etl-platform-five-challenges-and-architectural-lessons?utm_source=hashnode&utm_medium=feed) [MyData Insights](https://hashnode.com/@mydatainsights) · [Jul 6](https://hashnode.com/posts/fivetran-on-a-microsoft-stack-when-the-cost-is-worth-it/6a4b3043f94d61373e305241) ### [Fivetran on a Microsoft Stack: When the Cost Is Worth It](https://mydatainsights-blogs.hashnode.dev/fivetran-on-a-microsoft-stack-when-the-cost-is-worth-it?utm_source=hashnode&utm_medium=feed) Fivetran on a Microsoft Fabric stack: when maintained connectors are worth the licence over Azure Data Factory and Fabric. 5 min read · [mydatainsights-blogs.hashnode.dev](https://mydatainsights-blogs.hashnode.dev/fivetran-on-a-microsoft-stack-when-the-cost-is-worth-it?utm_source=hashnode&utm_medium=feed)