One of the key aspects of managing BI services is keeping them up to date. However, updates can sometimes introduce bugs and unexpected changes that may lead to issues.
For instance, in the May 2024 version of Power BI Report Server (On-Premise) connected to a SQL Server source, you might encounter an error when running DirectQuery reports.
To resolve this issue, follow these steps:
- Open “Edit the system environment variables” settings.
- In the “Environment Variables” section, select “New”.
- Set the following values:
- Variable name:
PBI_SQL_TRUSTED_SERVERS - Variable value:
* - Finally, restart the service or machine to apply the changes.