View on-premises reports and KPIs in the Power BI Windows app

Note

Power BI mobile app support for phones using Windows 10 Mobile has been discontinued as of March 16, 2021. Learn more

The Power BI app for Windows offers live, touch-enabled mobile access to your important on-premises business information in SQL Server 2016 Reporting Services.

Reporting Services mobile reports

First things first

Create Reporting Services mobile reports with SQL Server 2016 Enterprise Edition Mobile Report Publisher and publish them to the Reporting Services web portal. Create KPIs right in the web portal. Organize them in folders and mark your favorites, so you can find them easily.

Then in the Power BI app for Windows, view the KPS, mobile reports, and Power BI reports, organized in folders or collected as favorites.

Note

Your device needs to be running Windows 10 or higher. The app works best on devices with at least 1 GB RAM and 8 GB internal storage.

Explore samples without a SQL Server 2016 Reporting Services server

Even if you don't have access to a Reporting Services web portal, you can still explore the features of Reporting Services mobile reports.

To see the samples, tap the global navigation button in the upper-left corner and then select Samples.

Global navigation button

Six sample dashboards are available for Power BI, and two folders containing KPIs and mobile reports are available for Reporting Services.

Screenshot of samples and folders on the samples page.

Open the Retail Reports or Sales Reports folder to explore their KPIs and mobile reports.

Sample KPIs and mobile reports

Browse the samples to interact with KPIs and mobile reports.

Connect to a Reporting Services report server

  1. Tap Settings at the bottom of the navigation pane and then tap Connect to server.

    Screenshot of connect to server.

  2. Fill in the server address and your user name and password. Use this format for the server address:

    https://<servername>/reports OR https://<servername>/reports

    Note

    Include http or https at the beginning of the connection string.

    Tap Advanced option to give the server a name, if you'd like.

    Screenshot of connect to server-dialog.

  3. Tap the check mark to connect.

    Now you see the server in the nav pane.

    Server in nav pane

    Tip

    Tap the global navigation button Screenshot of global navigation button. anytime to go between your Reporting Services mobile reports and your dashboards in the Power BI service.

    Note

    Report Servers configured with custom ports are not supported and cannot be accessed from the Power BI Windows app.

View Reporting Services KPIs and mobile reports in the Power BI app

Reporting Services KPIs, mobile reports, and Power BI reports (preview) are displayed in the same folders they're in on the Reporting Services web portal.

Report folders

  • Tap a KPI to see it in focus mode.

    KPI in focus mode

  • Tap a mobile report to open and interact with it in the Power BI app.

    Reporting Services mobile report

View your favorite KPIs and reports

You can mark KPIs, mobile reports, and Power BI reports as favorites on your Reporting Services web portal, and then view them on your Windows device. Just click the Favorites icon in the nav pane to display the Favorites page, and then tap the tab that has your report server name.

Favorites icon

Tap the other tabs to filter your favorites in other ways.

Read more about favorites in the Power BI mobile apps.

Remove a connection to a report server

You can only be connected to one report server at a time from your Power BI mobile app. If you want to connect to a different server, you need to disconnect from the current one.

At the bottom of the nav pane, tap Settings, tap the server you want to disconnect from, and choose Remove server.

Remove server

Create Reporting Services mobile reports and KPIs

You don't create Reporting Services KPIs and mobile reports in the Power BI mobile app. You create them in SQL Server Mobile Report Publisher and a SQL Server 2016 Reporting Services web portal.

Next steps