topic Cannot Create Scheduled Refresh Plan in Report Server

Cannot Create Scheduled Refresh Plan

NigelDalley — Wed, 16 May 2018 14:34:39 GMT

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 created a data source which tested ok.

The problem is that when I try to create a Scheduled Refresh Plan I get an error message 'Something went wrong - Please try again later' . I can create a template Scheduled Refresh Plan under Site Settings and this has successfully created a SQL Agent job on the database. Yet even when I try to create a Refresh Plan against a report using this - it still fails.

The Report Server Service Account is running under 'Network Service' and the config file has the entry <RSWindowsNTLM/> within <AuthenticationTypes>. According to documentation I have read this is the only Authentication Type required when running service under 'Network Service'. I have also ensured <IsDataModelRefreshService> has the value True.

I have set the verbose logging level to 4 and gone through the log files including (RSPowerBI...log) but cannot find anything which identifies the issue.

Has anybody else had this problem and resolved it? Or is the functionality not available in this version?

Any advice would be very appreciated.

Re: Cannot Create Scheduled Refresh Plan

odi3 — Wed, 16 May 2018 19:49:37 GMT

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!

Re: Cannot Create Scheduled Refresh Plan

NigelDalley — Fri, 18 May 2018 08:23:14 GMT

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...

Re: Cannot Create Scheduled Refresh Plan

odi3 — Tue, 22 May 2018 13:49:27 GMT

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.