Power BI report server Schedule refresh

[FarrukhData]

Hi,

I have created a schedule refresh for my power bi report when i manually run that schedule refresh it works fine. So, just to test it out i have create a scheduled refresh for every 5 minutes and it's not starting automatically. 

So the last run was at may 6th 3:41 pm which i did manually and it refreshed fine. but after that it has been 24 hours did not run once. supposed to run every 5 minutes. 

[FarrukhData · Accepted solution]

Checked job activity monitor of the server in SSMS.

account was not allowed to run a job so i changed the account and it works fine now.  

[v-nmadadi-msft]

Hi @FarrukhData  ,
Thanks for reaching out to the Microsoft fabric community forum.

Not all Power BI reports are eligible for scheduled refresh. Below are the scenarios where creating a scheduled refresh plan is not supported, Please check if your scenario matches with any of the below which may have inadvertently caused the issue:

The report uses one or more Analysis Services data sources with a live connection.

 The report includes data sources configured for DirectQuery.

 The report has no underlying data source, such as when data is manually entered using Enter Data or the report consists solely of static content (e.g., images or text).

 The report contains dynamic data sources, where elements like server names, database names, or URLs are constructed dynamically based on report logic. In such cases, only the data sources detected at the time of publishing can be refreshed.

Source: Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[FarrukhData]

So I can see sql server is creating a job and as soon as the time hits schedule time it fails. anyone knows how to resolve this?

[FarrukhData]

Hi v-nmadadi-msft,

I have attached a screenshot below. I'm importing the data from sql server and the query has around 40 to 50k rows. nothing crazy just a simple datasource and a simple visual. still refresh doesn't work.