topic Power BI RS sept. 2024 - SQL Server databases no longer work in Report Server

Power BI RS sept. 2024 - SQL Server databases no longer work

chucky69 — Tue, 15 Oct 2024 08:38:46 GMT

Hi Petebro ,

Since Power BI RS september 2024 release, reports connected to SQL Server databases no longer work.

A connection error is systematic stating that the analysis services resource cannot be reached ?!?

Une erreur inattendue s'est produite. Réessayez plus tard.
Réessayez plus tard ou contactez le support. Si vous contactez le support, fournissez ces informations.

"Nous n'avons pas pu nous connecter au serveur Analysis Services. Vérifiez que vous avez entré correctement la chaîne de connexion.

ID de demande56836804-63f9-420b-fb0e-08cfebb12e3f

HeureTue Oct 15 2024 09:31:33 GMT+0200 (heure d’été d’Europe centrale)

Version du service/powerbi/libs"

The bug is persistant if i save the report with Power BI Desktop September 2024.

This same report works perfectly on a PBI RS January 2024.

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

lbendlin — Tue, 15 Oct 2024 23:00:06 GMT

That's not a SQL Server database, that is an OLAP cube. Please clarify.

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

chucky69 — Wed, 16 Oct 2024 08:39:36 GMT

Hi lbendlin

All the reports mentioned worked perfectly on all previous releases, at least since the January 2023 version of the report server.

The reports use a simple connection to a Sql Server database, with a database account.
This is the problem, the error reports, for no reason, an anomaly concerning an SSAS connection which does not exist.

Moreover, all my reports which use a connection on a multidimensional or tabular OLAP cube always work.

I read that this problem was already in the news in January 2021 (Solved: Re: Microsoft Power BI Report Server Connection is... - Microsoft Fabric Community).
This is not an SPN/Kerberos problem as we can read in this 2021 thread which strangely notes the same anomaly.

I actually can't wait for this issue to be fixed with the January 2025 release.

Petebro for help.

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

lbendlin — Wed, 16 Oct 2024 11:27:31 GMT

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

Petebro — Wed, 16 Oct 2024 14:51:37 GMT

I will also try to reproduce this issue.

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

Anonymous — Wed, 16 Oct 2024 22:35:20 GMT

Hi @chuncky69, I tried with PBIRS September Release and was able to connect to SQL Server with database authentication successfully. If you are still facing the issue, please contact the customer support. Thanks!

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

DMengY — Mon, 21 Oct 2024 13:46:18 GMT

Good day!
I have a similar error, as I understand there is no solution?

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

Petebro — Mon, 21 Oct 2024 15:27:12 GMT

We have been investigating the issue but are unable to reproduce it. There is likely some extra element at play here, but we need you to contact customer support to provide private information we cannot ask you to post here on the community pages. Thank you.

Re: Power BI RS sept. 2024 - SQL Server databases no longer work

chucky69 — Mon, 07 Jul 2025 11:27:20 GMT

Hello,
The solution is integrate environment variable PBI_SQL_TRUSTED_SERVERS on each server that carries a Report Server:

on the User part
on the System expected
value part = *

All reports that were crashing due to a direct query connection on a SQL Server database are running again on versions later than the January 2024 version.

Power Query SQL Server connector - Power Query | Microsoft Learn

Best regards