cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dwikar Regular Visitor
Regular Visitor

Power BI Report Server - Scheduled refresh not triggering

We have installed the lastest Power BI Report Server (October) which includes the features for scheduled data refreshes. The options for scheduling are now appearing in the options but they doesn't seem to trigger at all.

 

pbi-scheduling.png

 

Having gone through the https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot we still don't have any luck and the log isn't showing anything regarding scheduling.

 

Anyone got this working? Any suggestions for further troubleshooting?

 

Thanks in advance!

7 REPLIES 7
stretcharm Senior Member
Senior Member

Re: Power BI Report Server - Scheduled refresh not triggering

Those are the Shared Schedule definitions.

 

You need to add the schedule on each powerbi document.

Click the 3 dots on the powerbi doc and select Manage. Then add authentication before adding an entry under scheduled refresh.

You can also test it by selecting refresh now.

 

 

dwikar Regular Visitor
Regular Visitor

Re: Power BI Report Server - Scheduled refresh not triggering

We have set the schedules for the reports as well and "Refresh Now" is working - the scheduled refreshes are not firing though.

 

Thanks!

Moderator v-qiuyu-msft
Moderator

Re: Power BI Report Server - Scheduled refresh not triggering

Hi @dwikar,

 

Please go to SSMS, please execute the query below: 

 

Use <your report server DB name>
Go
select c.Path, c.Name,rs.ScheduleID,s.StartDate,s.LastRunTime,s.LastRunStatus from Catalog c
join [dbo].[ReportSchedule] rs on c.ItemID=rs.ReportID
Join Schedule s on rs.ScheduleID=s.ScheduleID

You will find the ScheduleID for the corresponding report, then go to SQL Server Agent -> Jobs, find the job based on ScheduleID, check the job history about this job. 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dwikar Regular Visitor
Regular Visitor

Re: Power BI Report Server - Scheduled refresh not triggering

Thanks @v-qiuyu-msft! This was just the kind of help and guidance I was hoping for.

 

Looking at the SQL Server Agent jobs now explains why it happened:

 

pbi-serveraccess.png

 

Next question is why and what to do about it? What kind of server access is missing for the account?

 

As an addition improved logging and some information directly through the portal would be appreciated for this.

 

Best regards,

Daniel

Moderator v-qiuyu-msft
Moderator

Re: Power BI Report Server - Scheduled refresh not triggering

Hi @dwikar,

 

Please click on the failed job and see detail message: 

 

q5.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dwikar Regular Visitor
Regular Visitor

Re: Power BI Report Server - Scheduled refresh not triggering

Thanks again @v-qiuyu-msft, unfortunately that doesn't really bring any more details (which makes it a bit hard to resolve).

 

pbi-serveraccess-details.png

stretcharm Senior Member
Senior Member

Re: Power BI Report Server - Scheduled refresh not triggering

 

Try a powerbi that just pulls something from a web site to see if the problem is the type of data source. It sounds weird if it works from refresh now as the schedule should use the same authentication.

 

Have you had a look at the log files?

 

%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

 

This file RSPowerBI_????.log

shows entries when my scheduled refresh runs.

 

 

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