cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fatemehdashti Frequent Visitor
Frequent Visitor

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 6
muchinski Member
Member

Re: can not create scheduled refresh plan

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.

fatemehdashti Frequent Visitor
Frequent Visitor

Re: can not create scheduled refresh plan

Thanks@muchinski, I set my user properties like below, Do you mean this? Unfortunatelly the error is shown again, Please guide me more.

1.jpg

Highlighted
muchinski Member
Member

Re: can not create scheduled refresh plan

Hi, I meant the user that connect PBIRS to the database. You can find it using Report Server Configuration Manager (image bellow).

Capture.PNG

 

In addition, do you see any error message on SQL Agent Log? 

Capture2.PNG

fatemehdashti Frequent Visitor
Frequent Visitor

Re: can not create scheduled refresh plan

Hi, my Report Server Configuration Manager is:

3.jpg

Also I set login properties for "NT AUTORITY\SYSTEM" like this:

4.jpg

But I still see some errors on SQL Agent log:

2.jpg

and It is showen previous error again whenI create a scheduled refresh plan. I'm really confuesed. What do I do now?

muchinski Member
Member

Re: can not create scheduled refresh plan

On your report server configurations, the connection is made with NT AUTHORITY\Network Service, but you gave permissions to NT AUTORITY\SYSTEM. They are different users -> I believe that this is the problem.

 

Why don’t you try to change the database configurations of your report server to use the built-in suggest account (more secure)? Or create a database user for your PBIRS authentication?

 

esmaeili New Member
New Member

Re: can not create scheduled refresh plan

did you find a solution for this?tnx

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors