Business Intelligence

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 in Test,(…)

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 your server.

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 The agenda(…)

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 to insight(…)

Data Platform Summit 2022 – Analytics at scale with Power BI and Azure Synapse

Introduction Introduction This morning I attended the first part of the pre-conf of the Data Platform Virtual Summit 2022 titled “Analytics at scale with Power BI and Azure Synapse” presented by Dave Ruijter. Working a lot with Power BI and(…)

Power BI – Active Directory data integration

Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link(…)

SSDT offline installation for Visual Studio 2019

Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was(…)

SQL Server – PolyBase Services when listening on all IP is disabled

Introduction You will find a lot of blogs explaining how to install the PolyBase feature with a SQL Server database instance. You will also learn how to configure it and how to use it in these blogs. But I could(…)

Power BI Report Server – URL reservation Warning – Delegation blocked

Introduction Recently I experienced some strange behavior on Power BI Report Server. My customer reported some failure when authenticating on shared data source using Kerberos delegation. On the test environment everything was working as expected and the delegation was working(…)

Copy or Migrate a SSISDB environment

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate(…)