Pinning a SQL Server Reporting Services Report to Power BI

By:   |   Comments (9)   |   Related: > Power BI


How do I pin a SQL Server Reporting Services (SSRS) report to Power BI Dashboards?


The improvements to SQL Server Reporting Services (SSRS) and Power BI just keep coming. In the latest SQL Server 2016 CTP 3.0 a new feature added to SSRS allows the direct pinning of specific objects to your online Power BI dashboards.

We will use the Adventure Works databases as the basis for our SSRS report development. The 2016 version of the regular databases are available on Codeplex: Once you download and install the SQL Server databases, we will subsequently use the SQL Server Data Tools for Business Intelligence (SSDT-BI) for Visual Studio 2013 to develop reports. You can download SSDT-BI from:

Pinning to Power BI

The process of pinning an object requires some initial setup before being able to pin an object for the first time. The first step centers around establishing a connection between SSRS and Power BI. To start the process, you must first connect to the Reporting Services Configuration Manager as shown below.

SSRS Config

Next you need to move to the Power BI integration tab. On this tab you need to register the connection to your previously created Power BI site. Additionally you must be an Azure AD tenant, a Reporting Services system administrator and a system administrator for the ReportServer catalog database in order to register the connection.

To complete the integration you will need to use the email address you used initially to register with on the Power BI site. Note: the registration process is currently restricted to company and organizations email addresses, so Gmail, Yahoo, and similar accounts are not able to register. The registration, as shown next, will validate your identity and then assure that you have proper access via your email account (second screen print below).

reg account

sign in

Once the registration is complete, you will see confirmation of success at the bottom of the screen. Furthermore, the registration ID and related account details will display in the middle of screen, similar to the below illustration. This window also allows you to unregister the connection or re-register the link.

reg complete

Now that the connection between your SQL Server 2016 Reporting Services server and your Power BI account is defined, we can now move on to your main report server screen. As displayed next, from the home page we first must click My Settings in the upper right corner of the screen. On the My Settings screen we can verify that we are logged in and connected to the Power BI site.

my setting

success sign in

If you are not signed in, then you can use the sign in button to sign into your Power BI account.

sign ing

Once the connection is validated on the My Settings screen, we can then navigate to the report which contains the object(s) we want to pin to the Power BI dashboard. Remember we can only pin gauges, charts, pictures, and maps. On the report viewer screen, a new Pin to Power BI button should be present and available to click on.

power bi button

After clicking the Pin to Power BI button, you must first select the object to be pinned.

select object

Now you are connected to your Power BI site and requested to select the dashboard to pin the object to and how often to refresh the dataset for the object.

select refresh and location

Finally, the object will then be pinned to the bottom of the selected dashboard.

Pinned Object

Limitations for SSRS Pinning to Power BI

A few caveats need to be mentioned about this newly pinned chart, graph or map. First, credentials must be stored in the report in order for the object to refresh. The pinning process actually creates a SSRS subscription which requires stored credentials in order to execute. Furthermore if you change the item name, the object will stop updating based on the subscription. Also if the pinned object is deleted, the related subscription is not deleted and must be removed manually. Lastly, if you try to pin an object and the SQL Server Agent is not running, the following error results. The SQL Server Agent where the SSRS database resides must be running in order to pin objects.

sql agent not running

Finally, as you are viewing the pinned object, you can actually click on the object tile which will link you back to the original report.

link to original report


We covered in this tip the methods of taking an object on a SSRS report and pinning it onto a Power BI Dashboard online. The process first requires your SSRS server to be connected or linked with your online Power BI account. Once connected, charts, graphs, maps, and images can then be pinned using the Pin Power BI button found on the report viewer screen. The pinned object gets added to the bottom of the selected dashboard and also provides a link back to the original report.

Next Steps

Learn more about Power BI in this 3 hour training course.

Click here to start the Power BI course

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Thursday, August 3, 2023 - 8:35:09 AM - STeven Back To Top (91460)
I am using SSRS 2022 standard and I am not seeing the power BI Integration tab in the report server configuration manager. Is there some step I need to perform to see this?


Tuesday, September 24, 2019 - 10:44:27 AM - Scott Murray Back To Top (82557)

Please check the permissions in Power BI that have been assigned to your user.

Tuesday, September 24, 2019 - 8:39:55 AM - prasanta kumar maharana Back To Top (82553)

I am getting an error while pining SSRS to Power BI - "The perimission granted to user '' are insufficient for performing this operation"

Please help me on this

Thursday, December 14, 2017 - 2:33:13 PM - Scott Murray Back To Top (74018)

 Not sure what protocol you are referring to.


Thursday, December 14, 2017 - 10:58:52 AM - M Ali Back To Top (74009)

Hi what protocol is used when ssrs is pinned to power bi and vice versa. My needs to ensure the data does not leave the 'secure' line.

SSRS is installed on a Azure VM.


Thank you

Friday, March 17, 2017 - 7:01:43 AM - Scott Murray Back To Top (51304)

You are correct with the pinning of the objects.


Sorry I am not familiar with pinning from Excel.

Friday, March 17, 2017 - 1:29:23 AM - Charles Back To Top (51279)

Hi Scott,

Thanks for your quick response.

Per my understanding for the paginated reports it also works to pin a tile to dashboard even the objects from the different page of the report, is that correct?

Also can you please explain weather it can pin from Excel range or a PBI desktop file? how it works?

I am a newer of the PBI, thanks for your patience and great support!




Thursday, March 16, 2017 - 7:04:30 AM - Scott Murray Back To Top (51227)


The pinning process only pins the selected object, not the whole report.

I have not tested a mobile report.


Thursday, March 16, 2017 - 3:40:54 AM - Charles Lee Back To Top (51204)

This tips quite useful for the newer to pin a SSRS report to online dashboard of power bi.

but there is not mentioned that if:

- it supported to pin from an SSRS 2016 mobile report

- or if it is a paginated report can be pined to a dashboard tile at one time or not.



-Thanks and Cheers,


get free sql tips
agree to terms