Sunday, October 30, 2016

Pin SSRS 2016 Reports to Power BI

To pin SSRS 2016 Report to Power BI,

  • Connections must use stored credentials
  • Only the following items can currently pinned using SSRS 2016 and Power BI Integration
    • Charts
    • Gauge panels
    • Maps
    • Images

a) Open SQL Server 2016 Reporting Services Configuration Manager and select Power BI Integration

SSRSPowerBI-Integration1

b) Register your SSRS Report Server with Power BI by clicking the Register with Power BI button and provide the necessary Power BI credentials.

SSRSPowerBI-Integration2

c) Go to your SSRS 2016 Portal and click on “My Settings”

SSRSPowerBI-Integration3

d) Make sure your SSRS is connected with Power BI

SSRSPowerBI-Integration4

e) Select the SSRS report to pin to Power BI and click the Power BI icon.

SSRSPowerBI-Integration5

f) Clicking the Power BI icon allows to select only the Chart and not the table. Currently it is a limitation and need to watch the space for any updates in the future.

SSRSPowerBI-Integration6

g) Click the Chart and Pin to PowerBI Dashboard dialog will appear and Select the Group, Dashboard and Frequency updates.

SSRSPowerBI-Integration8

h) Open Power BI and view the SSRS Chart

SSRSPowerBI-Integration9

Technorati Tags: ,

No comments:

Post a Comment