Forum Discussion
Report Server Schedule Refresh stays in Refreshing status
Hello, I have setup a Schedule Refresh in one PBI report on PBI Report server Premium. So I have a SQL agent job created with powerBIServer user on Report Server and running at the scheduled time...
Jon-Heide
Microsoft Employee
Microsoft EmployeeIt could be a number of issues. Suggest consulting the following, and looking at the server log files for more specific information.
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot
Thank Jon, I am checking that link..
Another thing is, Shedule refresh is working fine in UAT zone where i have same setup of server. The only diffrence is in UAT zone i have only couple of SQL agent jobs created from PBIRS and it works fine... but in PROD i have more than 50 jobs created and the new ones i am creating is not working.. i mean executing, showing status as Succeeded but no data refresh..
Is there any limitation on number of Power BI RS created sql jobs?
Thanks