Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I just created a new system variable named PBI_SQL_TRUSTED_SERVERS and put the server as its value. I can do direct query to that SQL Server now.

ZeyadHussein's avatar
ZeyadHussein
Regular Visitor
2 years ago

I can't find where specifically i can perfom this , thanks in advance...

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

    • azaki's avatar
      azaki
      Frequent Visitor
      1 year ago

      You are right
      and if you have multiable server seprate the names with COMMA (,)