Business Intelligence

Mastering Custom Integration Runtimes in Azure Data Factory: An Introduction to Our Upcoming Series

Introduction Dear Readers, This post serves as an introduction to a six-part series focused on the Integration Runtime (IR) within Azure Data Factory (ADF). Over the course of these six articles, you’ll gain essential knowledge and practical skills(…)

Developing a Business Central Custom API for Power BI Integration – Resolving the ‘Could Not Download Symbols’ Error

Introduction Dear Readers, This article marks my first blog post. I am both excited and eager to share my experience of tackling a challenging issue encountered while developing a custom API for Microsoft Business Central to enable data(…)

Power BI – Scheduled refresh stuck

Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be(…)

Cześć polska! SQLDay2024 in Wrocław

Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their(…)

Attending SQLDay 2024 in Wrocław, Poland

Here’s a short post about a conference I’m attending right now. SQLDay is one of the biggest events in Europe dedicated to the Microsoft data platform, including databases, Big Data and Business Intelligence solutions, and advanced data(…)

Power BI Report Server: unable to publish a PBIX report

Introduction I installed a complete new Power BI Report Server. The server had several network interfaces to be part of several subdomains. In order to access the Power BI Report Server web portal from the different subdomains I defined(…)

Programmatically change the data source of a Power BI Report

Executive Summary In this post, I want to demonstrate how to programmatically change the data source of a Power BI report. This can be useful when you develop and test the report then want to publish the report(…)

Power BI Report Server Patch Management

Executive Summary As service manager in your company, you want to have your MS SQL component patch with the latest version. In a regular basis you need to know the current version of the MS SQL components on(…)

Data Platform Summit 2022 – Cracking Power BI Performance Tuning In A Day!

Introduction The second pre-conf I attended was about tuning Power BI. I was curious to hear and learn from Nikola  Ilic, who presented the session, what his experience and technique are dealing to solve Power BI performance issues(…)

SQL Server 2022 – Azure Synapse Link

Why is this feature interesting? The Azure Synapse Link for SQL Server 2022 will enable you to replicate your operational data into Azure Synapse Analytics dedicated SQL pool. Azure Synapse is an enterprise analytics service that accelerates time(…)