Forum Discussion
Power BI RS sept. 2024 - SQL Server databases no longer work
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 LearnBest regards
That's not a SQL Server database, that is an OLAP cube. Please clarify.
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.
I will also try to reproduce this issue.
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!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 .
