{"id":1851,"date":"2026-03-09T16:59:00","date_gmt":"2026-03-09T16:59:00","guid":{"rendered":"https:\/\/bitnext.pixdev.hu\/?p=1851"},"modified":"2026-09-11T07:19:26","modified_gmt":"2026-09-11T05:19:26","slug":"transaction-based-data-synchronization-between-sql-servers-to-power-bi-server","status":"publish","type":"post","link":"https:\/\/bitnext.hu\/en_gb\/tranzakcioalapu-adat-szinkronizacio-sql-szerverek-kozott-power-bi-kiszolgalasara\/","title":{"rendered":"Transaction-based data synchronisation between SQL servers for Power BI"},"content":{"rendered":"<div class=\"bn-article-body\">\n<p class=\"bn-article-lead\">A dedicated SQL environment receives changes from the source system every 15 minutes and serves Power BI business reports. A coordinated workflow, from data ingestion to queries, supports day-to-day decisions.<\/p>\n<details class=\"bn-article-toc\">\n<summary>Contents<\/summary>\n<nav aria-label=\"Contents\">\n<ol>\n<li><a href=\"#resz-1-a-feladat-naprakesz-adatok-az-uzleti-dontesekhez\">The task: up-to-date data for business decisions<\/a><\/li>\n<li><a href=\"#resz-2-az-adatok-utja-harom-lepesben\">The data flow in three steps<\/a><\/li>\n<li><a href=\"#resz-3-milyen-riportokat-szolgal-ki-a-rendszer\">Which reports does the system support?<\/a><\/li>\n<li><a href=\"#resz-4-uzemeltetheto-es-vedett-hatter\">A manageable, protected environment<\/a><\/li>\n<li><a href=\"#resz-5-mit-jelent-ez-az-ugyfel-szamara\">What does this mean for the client?<\/a><\/li>\n<\/ol>\n<\/nav>\n<\/details>\n<h2 id=\"resz-1-a-feladat-naprakesz-adatok-az-uzleti-dontesekhez\">The task: up-to-date data for business decisions<\/h2>\n<p>The client uses Power BI reports for day-to-day decisions. It needed a data source that regularly receives changes from the source system and supports sales, inventory and transaction reports.<\/p>\n<p>BitNext built an SQL environment on a dedicated Windows-based VPS. Data ingestion focuses on changed records, avoiding the need to process the entire dataset again each time.<\/p>\n<h2 id=\"resz-2-az-adatok-utja-harom-lepesben\">The data flow in three steps<\/h2>\n<ol>\n<li><strong>We retrieve the changes.<\/strong> New and modified transactions arrive from the source system through an API connection.<\/li>\n<li><strong>We check and load the data.<\/strong> The data processing workflow validates and transforms the records before writing them to the target database. It logs events and errors.<\/li>\n<li><strong>Power BI queries the SQL database.<\/strong> Reports use the prepared database, with queries tuned to the VPS's capacity.<\/li>\n<\/ol>\n<p>We track changes using each record's last modification timestamp. In this project, data is refreshed every 15 minutes, so this schedule also determines how current the reports are.<\/p>\n<h2 id=\"resz-3-milyen-riportokat-szolgal-ki-a-rendszer\">Which reports does the system support?<\/h2>\n<ul>\n<li><strong>Sales overview:<\/strong> following sales data in one place.<\/li>\n<li><strong>Inventory turnover report:<\/strong> reviewing stock movements and turnover.<\/li>\n<li><strong>Transaction log analysis:<\/strong> finding and examining individual business events.<\/li>\n<\/ul>\n<p>Power BI's DirectQuery connection queries the SQL database directly. Fast responses therefore required tuning the database structure and queries as well as the reports themselves.<\/p>\n<h2 id=\"resz-4-uzemeltetheto-es-vedett-hatter\">A manageable, protected environment<\/h2>\n<p>The system runs in an isolated Windows Server environment with Microsoft SQL Server. Access is protected with firewall rules, IP-based restrictions and encrypted connections.<\/p>\n<p>The solution includes automatic backups and system monitoring. Data processing logs help identify failures during ingestion or refresh operations.<\/p>\n<h2 id=\"resz-5-mit-jelent-ez-az-ugyfel-szamara\">What does this mean for the client?<\/h2>\n<p><strong>The reports use a dedicated data source that is refreshed regularly.<\/strong> Sales, inventory and transactions can be analysed from the same SQL environment.<\/p>\n<p>Targeted processing of changed data reduces repeated data transfers, while logging makes refresh operations easier to follow. A dedicated VPS also allows the environment to be tailored to the client's needs.<\/p>\n<details class=\"bn-article-details\">\n<summary>Technical details<\/summary>\n<div class=\"bn-article-table\">\n<table>\n<thead>\n<tr>\n<th scope=\"col\">Component<\/th>\n<th scope=\"col\">Configuration<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Virtual server<\/td>\n<td>Windows Server 2022, 4 vCPUs, 16 GB of memory and SSD storage.<\/td>\n<\/tr>\n<tr>\n<td>Database<\/td>\n<td>Microsoft SQL Server 2022 Standard with a dedicated database, indexing and partitioning.<\/td>\n<\/tr>\n<tr>\n<td>Data ingestion<\/td>\n<td>API-based ingestion and SSIS processing; changes tracked using the last modification timestamp.<\/td>\n<\/tr>\n<tr>\n<td>Refresh<\/td>\n<td>Data refreshed every 15 minutes, with logging and error checks.<\/td>\n<\/tr>\n<tr>\n<td>Reporting connection<\/td>\n<td>Power BI DirectQuery, with queries tuned to the server.<\/td>\n<\/tr>\n<tr>\n<td>Operations<\/td>\n<td>Automatic backups, system monitoring and controlled access.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/details>\n<div class=\"bn-article-cta\">\n<p>Need a regularly refreshed data source for your Power BI reports? Tell us where the data comes from, and we will help build the supporting environment.<\/p>\n<p><a class=\"elementor-button\" href=\"https:\/\/bitnext.hu\/en_gb\/contact\/#kapcsolatiform\">REQUEST A QUOTE<\/a><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>A dedicated SQL environment receives changes from the source system every 15 minutes and serves Power BI business reports. A coordinated workflow, from data ingestion to queries, supports day-to-day decisions.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-1851","post","type-post","status-publish","format-standard","hentry","category-esettanulmany"],"_links":{"self":[{"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/posts\/1851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/comments?post=1851"}],"version-history":[{"count":9,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/posts\/1851\/revisions"}],"predecessor-version":[{"id":2565,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/posts\/1851\/revisions\/2565"}],"wp:attachment":[{"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/media?parent=1851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/categories?post=1851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bitnext.hu\/en_gb\/wp-json\/wp\/v2\/tags?post=1851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}