Also known as Power BI Integration
SSRS 2016 has the ability to pin reports to Power BI.
While this sounds great, the process has limitation, and the SSRS reports displayed in Power BI feel a bit flat. Still, it is a nice addition. Just don't expect magic.
To make this happen, there are several steps to be done.
- Connect the SSRS server to the Power BI corporate portal
- Connect your personal SSRS account to your personal Power BI account
With the initial connections setup, you can pin selected SSRS reports to your Power BI account. Here are the detailed steps to get started.
Connect the SSRS server to the Power BI corporate portal
Your IT department completes the first requirement. On the SSRS server, using Reporting Services Configuration Manager, IT sets up an administrative connection from the SSRS server to Power BI. This is a one-time configuration. At the bottom of the configuration manager you will find the page to get started. You will need to be an SSRS administrator, and typically, this will use a Power BI administrative account.
Click on the Register button, and the Power BI login page pops up. Login to Power BI.
Connect your personal SSRS account to your personal Power BI accountWith the SSRS server setup with Power BI integration, the next step is to configure your personal account on SSRS with a connection to your Power BI account. Using any HTML5 compliant browser, such as Chrome or Edge, connect to the SSRS reports page. Under Settings, go to My Settings.
This brings up the Connect to Power BI page.
Use the Sign In button to bring up the sign in page, and add in your Power BI account information. Don't forget that Power BI requests password changes, so you may need to change this in the future.