Power BI Report Server

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

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).

Save Report to Power BI Report Server: Resolving the ‘Unexpected Error Encountered’

1        Introduction Hello, Readers! Recently, I was tasked with preparing a demo for Power BI Report Server. Everything proceeded smoothly until I reached the step of deploying a report to the server, where I encountered an interesting authentication(…)

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

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

Power BI Report Server Kerberos Setup

In the case you have the following configuration and requirements Your Power BI, paginated mobile KPI reports are published on your on premise Power BI Report Server (Named i.e. SRV-PBIRS), their data sources is an Analysis Services located on another(…)