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

Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

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.