Forum Discussion

dwikar's avatar
dwikar
Helper I
8 years ago

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 s...
Report Server
Report Server + PBI Premium
Report Server On premises
dwikar's avatar
dwikar
Helper I
8 years ago

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:

 

 

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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi dwikar,

 

Please click on the failed job and see detail message: 

 

 

 

Best Regards,
Qiuyun Yu

  • dwikar's avatar
    dwikar
    Helper I
    8 years ago

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

     

    • stretcharm's avatar
      stretcharm
      Memorable Member
      8 years ago

       

      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.