SQL Server 2016 Reporting Services (SSRS) enables users to pin Reporting Services report items from the report viewer toolbar to a Power BI dashboard as a new tile. To pin, your administrator needs to first integrate your report server with Azure Active Directory and Power BI.
Applies to: Reporting Services Native Mode
Requirements to Pin
The report server is configured for Power BI integration. For more information, see Power BI Report Server Integration (Configuration Manager). If the report server has not been configured, you will not see the Pin to Power BI Dashboard button the toolbar.
You pin from the Reporting Services report viewer in tweb portalhe , for example
http://myserver/Reports. You cannot pin from Report Builder, from report designer in SQL Server Data Tools (SSDT), or from a report server url. For example
Your browser needs to be configured to allow pop-ups from your report server site.
Reports need to be configured for stored credentials if you want the pinned item to refresh. When you pin an item, a Reporting Services subscription is automatically created to manage the data refresh of the item to the dashboard. If the report does not use stored credentials, the when the subscription runs, you will see an error message similar to the following on the My subscriptions page.
PowerBI Delivery error: dashboard: IT Spend Analysis Sample, visual: Chart2, error: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credential.
See the section "Configure stored credentials for a report-specific data source (Native mode)" in Store Credentials in a Reporting Services Data Source
Items You Can Pin
The following report items can be pinned to a Power BI dashboard. You cannot pin items that are nested inside a data region. For example you cannot pin an item that is nested inside a Reporting Services table or list.
Items need to be in the report body. You cannot pin items that are in the page header or page footer.
You can pin individual items that are inside a top level rectangle but you cannot pin them all as a single group.
To Pin a Report Item
Verify you are signed into Power BI. In the Reporting Services web portal, select the menu item My Settings and sign in. See My Settings for Power BI Integration (web portal) for more information.
Navigate to the web portal folder that contains your report, and then view the report.
While viewing the report, select the Pin to Power BI button the toolbar. You will be prompted to sign in, if you are not already signed in. If the Power BI button is not visible, the report server has not been integrated with Power BI. For more information, see Power BI Report Server Integration (Configuration Manager).
Select the report item you want to pin to Power BI. You can only pin one item at a time. The report viewer presents a shaded view of your report and the report items you can pin are highlighted while the items that you cannot pin, will be shaded dark.
(1) select the group that contains the dashboard you want to pin to, (2) select the dashboard you want to pin the item too and (3) select how frequently you want the tile updated in the dashboard. The refresh is managed by Reporting Services subscriptions and after the item is pinned, you can edit the subscription and configure a different refresh schedule.
In the Pin Successful dialog, you can select the link See it in Power BI to navigate to the dashboard and see the item you just pinned.
Select Close to return the report to the normal view.
In the Dashboard
After your report item is pinned in the dashboard, the tile looks like other dashboard tiles and there is no visible indication the tile came from Reporting Services. The following list summarizes how tile properties are populated from the report item.
From the Power BI dashboard the pinned report item behaves like other tiles:
(1) You can pin the tile to other dashboards.
(2) In the Tile Details you will notice the Reporting Services report title is used for the default title of the tile.
(3) The tile subtitle is based on the date and time the tile was pinned or the data was last refreshed from Reporting Services. The refresh schedule is managed by the Reporting Services subscription that was automatically created when you pinned the report item.
(4) If you select the tile itself, Power BI uses the (3) custom link to navigate to the web portal page of the registered report server. the link was set when the item was pinned from Reporting Services. If you do not have internet connectivity to the report server, you will see an error in the browser.
No Power BI button on the report viewer toolbar: This indicates the report server has not been integrated with Power BI. For more information, see Power BI Report Server Integration (Configuration Manager).
Cannot Pin: When you attempt to pin an item, you see the following error message: See the section Items You Can Pin.
Cannot Pin: There are no report items on this page that you can pin to [!INCLUDE[sspowerbi](../includes/sspowerbi-md.md)].
Pinned items show stale data in a Power BI dashboard and it did update for a period of time. The user credentials token has expired and you need to sign in again. The user credential registration with Azure and Power BI is good for 90 days. In tweb portalhe , click My Settings. For more information, see My Settings for Power BI Integration (web portal).
Pinned items show stale data in a Power BI dashboard and it has not refreshed even once. The issue is the report is not configured to use stored credentials. A report must used stored credentials because the action of pinning a report item creates a Reporting Services subscription to manage the refresh schedule of the tiles. Reporting Services subscriptions require stored credentials. If you review the My Subscriptions page, you see an error message similar to the following:
PowerBI Delivery error: dashboard: SSRS items, visual: Image3, error: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)
Expired Power BI credentials: You attempt to pin an item and see the following error message. In the web portal, click My Settings and on the My Settings page, click Sign in. See My Settings for Power BI Integration (web portal) for more information.
Cannot Pin : Unexpected Server Error: Missing, invalid or expired Power BI credentials.
Cannot Pin: If you attempt to pin an item to a dashboard that is in a read-only state, you will see an error message similar to the following:
Server Error : The item 'Dashboard deleted 015cf022-8e2f-462e-88e5-75ab0a04c4d0' cannot be found. (rsItemNotFound)
In addition to the subscription related issues described in the troubleshooting section, the following information will help you maintain Power BI related subscriptions.
Item name changed: If a pinned report item is renamed or deleted, the Power BI tile will no longer update and you will see an error message similar to the following. If you rename the item back the original name, the subscription will start working again and the tile will be refreshed on the subscriptions schedule.
PowerBI Delivery error: dashboard: SSRS items, visual: Image1, error: Error: Report item 'Image1' cannot be found.
You could also edit the subscription properties and change the Report Visual Name to the appropriate report item name.
Delete a tile. If you delete a tile in Power BI, the associated subscription is not deleted in Reporting Services and on the My subscriptionspage, you see an error similar to the following. You can delete the subscription.
PowerBI Delivery error: dashboard: SSRS items, visual: Image3, error: The item 'Tile deleted af7131d9-5eaf-480f-ba45-943a07d19c9f' cannot be found.