Forum Discussion
can not create scheduled refresh plan
Hi everybody, Please help me
When I want to create scheduled refresh plan, this error occures:
****The SQL Agent service is not running, This option requires the SQL Agent service.****
I checked my SQL Agent service in Microsoft SQL Server Management and started it but above error is shown again and not solved.
How can I solve this error and create an scheduled refresh plan?
Note that I get data from sql server DB with Import option.
6 Replies
Hi fatemehdashti, the user account used to connect Power BI Reporting Services Service to the Report Server database must be, at least, member of the SQLAgentOperatorRole on msdb database, in order to create jobs. (refresh plans create jobs internally to deal with schedules)
Can you check that? It is a permission on the server that hosts the Report Server database.
Thanksmuchinski, I set my user properties like below, Do you mean this? Unfortunatelly the error is shown again, Please guide me more.
Hi, I meant the user that connect PBIRS to the database. You can find it using Report Server Configuration Manager (image bellow).
In addition, do you see any error message on SQL Agent Log?
