Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PowerBI integration with SSRS 2016

There is a task to integrate PowerBI into the SSRS 2016, but inside the corporate network. proxy servers are selected and registered. I see an invitation for authorization, I enter a username and pas...
Need Help
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You can change the Trace log configuration file ReportingServicesService.exe.config located in the following folder: \Program Files\Microsoft SQL Server\MSRS13.<instance name>\Reporting Services\ReportServer\bin, change the setting "DefaultTraceSwitch" to 4 can enable the verbose mode.

 

The trace log files are ReportServerService_<timestamp>.log and Microsoft.ReportingServices.Portal.WebHost_<timestamp>.log and are located in the following folder:  C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

 

You can find more detail about the log setting of SSRS in this document , and refer to the requirement about Integration in this document.

 

If you get error while sign in to AAD, you can refer to this similar post: https://community.powerbi.com/t5/Service/SSRS-Server-Power-BI-Integration-Error-Failed-to-sign-in-to/td-p/74917

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

i haven't path C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Maybe you install the SQL Server in another folder, try the following steps to determine the installation folder.

     

    1. Press the Windows® logo key + R to open the Run window.
    2. Type Services.msc.
    3. Click OK to open the Services window.
    3. Right-click the Time Matters® SQL Server or SQL Browser service.
    4. Click Properties to open the SQL Server (Instance) or Browser Properties window.
    4. The path listed under Path to Executable is the path to the SQL Server or Browser service.

     

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Directory of C:\Program Files (x86)\Microsoft SQL Server

      26.08.2019 16:04 <DIR> .
      26.08.2019 16:04 <DIR> ..
      09.07.2019 15:52 <DIR> 100
      09.07.2019 15:51 <DIR> 110
      09.07.2019 15:52 <DIR> 130
      19.03.2019 12:18 <DIR> 140
      09.07.2019 15:51 <DIR> 80
      09.07.2019 15:51 <DIR> 90
      09.07.2019 15:51 <DIR> Client SDK
      26.08.2019 16:04 <DIR> Report Builder

       

      and same directory in C:\Program Files\Microsoft SQL Server

       

       

       

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous ,

         

        Is it your SQL Server Browser execuable path? I think that maybe your SQL Server Instance is installed in another path.

         

        Best regards,

        Community Support Team _ Dong Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.