Forum Discussion
Error while scheduling refresh for reports on Power BI report server
While trying to schedule a refresh for any report on my report server, the following error is returned (Screenshot attached).
All data source verifications are sucessfull and the report is manually refreshed without errors. The older schedules are working perfectly but I am unable to schedule a new one. Please help
Hi Moosa-Ali ,
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...
An you alos could try the following solution:
The fix is to grant sysadmin Privilege to Report server service account .
Similar question refer:(final it was actually an authorization issue, the virtual account lacked some sort of permissions so user changed to a domain account and now it works fine)
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
5 Replies
Hi Moosa-Ali ,
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...
An you alos could try the following solution:
The fix is to grant sysadmin Privilege to Report server service account .
Similar question refer:(final it was actually an authorization issue, the virtual account lacked some sort of permissions so user changed to a domain account and now it works fine)
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Can you provide a little more details. What types of data sources are being used in the reports for example?
Our data source is MSSQL Server on-premises. Data is loaded from this SQL server into Power BI.
I beileve it would be helpful to mention here that we are using the free version of Power BI, could that be an issue?
Hi Moosa-Ali ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
