Symptoms

Assume that you configure SQL Server 2016 Reporting Services (SSRS 2016) report server for Power BI integration. When you pin a report from the Reporting Servers report viewer, for example, http://myserver/Reports, to a Power BI dashboard, and you don't have edit permissions to any groups in Power BI, except for the default group "My Workspace", you receive the following error message:

You don’t have any dashboards
You need at least one dashboard that you have permissions to pin to.


Resolution

Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:


More Information

SSRS 2016 enables users to pin Reporting Services report items from the report viewer toolbar to a Power BI dashboard as a new tile. For more information, see Power BI Report Server Integration (Configuration Manager) and Pin Reporting Services items to Power BI Dashboards.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×