Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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 password, authorization does not go on azure ad. Actually the question is, how to enable debugging to see the extended error code? thank you

Need Help

6 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 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
      6 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
        6 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.