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