Forum Discussion
Power BI report server Schedule refresh
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.
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
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.