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

[chucky69]

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.

[chucky69 · Accepted solution]

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

1. on the User part
2. on the System expected
3. 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

[Petebro]

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.

[DMengY]

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

[lbendlin]

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

[chucky69]

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.

[benjaminb]

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!

[Petebro]

I will also try to reproduce this issue.

[lbendlin]

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 .