Forum Discussion
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...
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
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