Monday, March 28, 2016

Connect SSRS 2016 to Power BI

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.

Initial Setup
  1. Connect the SSRS server to the Power BI corporate portal
  2. Connect your personal SSRS account to your personal Power BI account

Pin Reports
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.


If successful, your Power BI Integration page in Reporting Services Configuration Manager will look something like the following:



Connect your personal SSRS account to your personal Power BI account

With 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.




That's it, your SSRS account is now connected to your Power BI account, and you can start to pin reports to Power BI.  Keep in mind that only paginated (traditional) SSRS reports can be pinned to Power BI. And those reports require stored credentials.

Pin a report to Power BI:











No comments: