Forum Discussion
Power BI report Server issue with Direct Query to SQL Server database
Hi everyone I have Power BI Report server, and power bi desktop for RS (May 2024) installed. I tried to create very first report using Direct Query to a SQL Server database. It works normally in Powe...
Subject already covered in the following post.. Solved: Re: Issues regarding power bi report server - Microsoft Fabric Community
I think it will help you !
Fabien
I can't find where specifically i can perfom this , thanks in advance...
First find "Edit the system environment variables" from start menu
Then following steps below:
- Click on Environment Variables
- If there is nothing named PBI_SQL_TRUSTED_SERVERS , Click New and then put the name and servers
- If the variable is there, you can select it and hit click Edit...
Hope this help
You are right
and if you have multiable server seprate the names with COMMA (,)
