Forum Discussion

NigelDalley's avatar
NigelDalley
Regular Visitor
8 years ago

Cannot Create Scheduled Refresh Plan

I have installed Report Server (October 2017 version) and the correct desktop app.  I can create a report (using Import option) and upload it to the Report Server ok.  Report runs fine...  I then cre...
Report Server
Scheduled data refresh
odi3's avatar
odi3
Frequent Visitor
8 years ago

I fought with getting this to work for a straight week.....

 

to schedule refresh a report, the execution account must have "system user" permissions.

the system administrator permission alone does not allow a user to schedule refresh a report.

 

Some other things to try:

 

Set the execution account in the setup of power bi to a specific user

make sure sql server has the proper permissions for that user

make sure the powerbi server cog->settings->site settings->security is giving access to that user

Make sure the user has permissions to the report. rightclick on the report -> security -> add user

 

 

Hope this works for you!

NigelDalley's avatar
NigelDalley
Regular Visitor
8 years ago

Thanks odi3

 

Will check it out....

 

Just to clarify - regarding 'Set the execution account in the setup of power bi to a specific user' - are you referring to the service account power bi is running under as currently it is using 'NT AUTHORITY\NETWORK SERVICE' ?

 

Thanks again for suggestions...

  • odi3's avatar
    odi3
    Frequent Visitor
    8 years ago

    services account and execution account are two different things.

     

    Service account is the top item in the power bi install screen whereas execution account is about the 5th item down.

     

    To use scheduled refresh, you do not have to modify the services account.