Business Intelligence

A Misleading SSAS Error in Power BI Report Server When Using DirectQuery Mode

Our client was experiencing issues after publishing a report that used Direct Query mode. Specifically, when the report was queried, the following error occurred: Error :  We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection(…)

SQLDay 2026 Workshops Overview

SQLDay 2026 offers a full-day workshop program on 11 May 2026, before the main conference scheduled for 12–13 May 2026 in Wrocław, with onsite and online participation options depending on the session. The workshops cover several areas of(…)

Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025

Migrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.

SQL Server’s LinkedIn Posts catch-up!

You may not have followed all my posts this summer about what we are doing with Microsoft SQL Server technology and the BI stack like Power BI and Azure Data Fabric. So, I thought I’d write a little catch-up blog(…)

Metadata-driven pipelines : la continuité du Master Package SSIS

Organiser des flux, c’est une question qui m’a accompagné tout au long de ma carrière. Quand j’ai commencé avec les ETL, j’ai appris “à l’ancienne” : toutes les règles de gestion codées directement dans les packages. Une approche rigide, lourde(…)

Data Point Prague – Session avec Mark Lelijveld

Les 29 et 30 mai dernier (oui, j’ai pris un peu de temps pour écrire mon blog suite à un planning un peu trop chargé) j’ai assisté à la DataPoint à Prague. Avant de parler plus des sessions auxquelles j’ai(…)

Exploring the Future of Data at SQLBits 2025 in London

I’m looking back on three amazing days of interesting technical insights from the SQLBits event 2025 in London. It’s actually my first time having the pleasure of attending one of Europe’s biggest data platform events and I can sincerely say,(…)

SQL Server 2025 – Retirement of SQL Server Reporting Services (SSRS)

Microsoft has announced the end of the SQL Server Reporting Services (SSRS) service. In other words, Microsoft will no longer provide new versions of SSRS. Currently, the latest available version is the 2022 version (https://www.microsoft.com/fr-FR/download/details.aspx?id=104502). However,(…)

Experiencing SQLBits 2025 in London

This week, I’m in London attending the SQLBits 2025 conference.Since joining dbi services as a consultant, this is my second time taking part in the event. The last time was in 2022, but I attended remotely due to the(…)

SQLDay 2025 – Wrocław – Sessions

After a packed workshop day, the SQLDay conference officially kicked off on Tuesday with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more. Here is a short overview of the sessions I attended on the first day(…)