Forum Discussion

chucky69's avatar
chucky69
Frequent Visitor
1 year ago
Solved

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

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 canno...
PBI RS 2024
  • chucky69's avatar
    chucky69
    1 year ago

    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

chucky69's avatar
chucky69
Frequent Visitor
1 year ago

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago
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!