none
How SSRS 2016 publish to internet accessed by Mobile device ? RRS feed

  • Question

  • Dears,

    I have set up SQL Server Reporting Services 2016 and integrated with Power BI desktop under intranet environment after install the technical preview.

    https://www.microsoft.com/en-us/download/details.aspx?id=54610

    However, may I know how to configure the SSRS 2016 so the url could be publish to internet and access by Power BI mobile apps or browser in mobile device ?

    Does below link ?

    https://docs.microsoft.com/en-us/sql/reporting-services/report-server/enable-a-report-server-for-power-bi-mobile-access

    Thanks !

    Andy Wong

    Wednesday, April 26, 2017 6:10 AM

All replies

  • Hi Andykm.Wong,

    Based on my research, if you want to publish url to internet, you need to follow the next configurations:

    1. Install Reporting Services on an Internet-facing Web server using the files-only installation mode. In SQL Server Installation Wizard, this is the Install but do not configure option.

    2. Create and deploy a custom security extension to support forms authentication or a single-sign on technology.

    3. Configure Report Manager for minimal permissions. The Browser role and System User role are sufficient for viewing reports.

    4. To point Web Portal to a different report server instance that runs on a separate computer, you must configure the Web Portal URL and then modify the <ReportServerVirtualDirectory> and <ReportServerUrl> settings in the RSReportServer.config file to point Web Portal to the report server instance.

    5. On the report server that you are connecting to, turn off features that you will not use. Examples might include My Reports, subscription and delivery, Report Builder, and client-side printing.

    You can refer to Planning for Extranet or Internet Deployment for details. After you complete configuration, you can view it by browser in mobile device.

    In addition, you can use Power BI mobile app to view it directly. Before you can access report by Power BI mobile app, you need to make sure you use Native Mode instance, configure basic authentication, enable HTTPS in Reporting Services and configure firewall settings to ensure that all devices can connect successfully to Reporting Services. You can refer to Enable a report server for Power BI Mobile access for details. Then you can use http://<Servername>:port/Reports in Power BI to connect SSRS.  

    If you have any question, please feel free to ask.

    Best regards,

    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Friday, April 28, 2017 4:14 AM
    Moderator