For organizations who have invested in the Power BI cloud service, this nifty feature allows users to pin graphical SSRS report visuals to their online dashboards. 

Requirements to enable this feature:

  • Register the report server with a Power BI subscription
  • SQL Server Agent must be running on the database server with the report server catalog (this is always been an SSRS requirement.)
  • User must have access to the Power BI subscription

Reporting Services Configuration Manager includes a new page to manage Power BI Integration.  This is where you register the report server instance with the Power BI subscription.

When a report with “pinnable” items (such as images, charts and gauges) is viewed in Report Portal, the Power BI icon is displayed on the toolbar.

Items are highlighted and when a visual is selected, you are prompted to select a Power BI dashboard and the refresh frequency.  This schedules an Agent job on the report server to push updated visuals to the dashboard at the selected frequency.

Pinned report visuals appear on the dashboard alongside the Power BI report and Excel visuals.  Clicking on one of these visuals will drill-through to the report back on the on-premises report server.  This gives users a seamless navigation experience between cloud-hosted Power BI content and selected report visual elements on your own report server.