An error occurred within the report server database. SSRS PowerBI Pin

[dunsmonj]

I have SSRS 2016 and PowerBI, I am trying to pin a graph to my dashboard, I can select the dashboard but when I hit PIN I get this error message "

Can’t Pin to Power BI

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)"

The connectiosn are fine, PowerBI is integrated. The server resources on the report server are also properly working.

Any ideas?

[v-qiuyu-msft · Accepted solution]

Hi @dunsmonj,

From the error message, we can know the issue is caused by the connection to report server database. In your scenario, I would suggest you check detail error information in Reporting Services error log (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles) around the time that the error message thrown out.

If you see the error "System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding" in log files, the issue is that the connection to report server database is timeout. Then you can follow Jin's suggestion to fix the issue: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An e... 

To pin a Reporting Services item to Power BI dashboard, there are many requirements need to meet, please go through this article: Pin Reporting Services items to Power BI Dashboards.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu           

[v-qiuyu-msft · Accepted solution]

Hi @dunsmonj,

From the error message, we can know the issue is caused by the connection to report server database. In your scenario, I would suggest you check detail error information in Reporting Services error log (default location: %programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles) around the time that the error message thrown out.

If you see the error "System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding" in log files, the issue is that the connection to report server database is timeout. Then you can follow Jin's suggestion to fix the issue: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An e... 

To pin a Reporting Services item to Power BI dashboard, there are many requirements need to meet, please go through this article: Pin Reporting Services items to Power BI Dashboards.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu           

[dunsmonj · Accepted solution]

It was actually an authorization issue, the virtual account lacked some sort of permissions so I changed to a domain account and now it works fine.

Terrible error message