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
- Gauge panels
a) Open SQL Server 2016 Reporting Services Configuration Manager and select Power BI Integration
b) Register your SSRS Report Server with Power BI by clicking the Register with Power BI button and provide the necessary Power BI credentials.
c) Go to your SSRS 2016 Portal and click on “My Settings”
d) Make sure your SSRS is connected with Power BI
e) Select the SSRS report to pin to Power BI and click the Power BI icon.
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.
g) Click the Chart and Pin to PowerBI Dashboard dialog will appear and Select the Group, Dashboard and Frequency updates.
h) Open Power BI and view the SSRS Chart