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...
  • stanley_1913's avatar
    stanley_1913
    New Member
    2 years ago

    Thanks a lot for sharing how to solve the problem. 

  • 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