Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 "
Solved! Go to 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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |