Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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 interval and shows status Succeeded. But Data is not refreshed and also status is showing "Refreshing". Please see the attachment..schedulerefresh.png

 

Any idea ?

4 REPLIES 4
Sachin09
Employee
Employee

I have same issue can anyone have any solution. Please help me

Jon-Heide
Employee
Employee

It 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

 

Anonymous
Not applicable

@Jon-Heide - Can you help what is the solution along with the steps to the issue mentioned above.

I did check the execution log, but I could not find any resolution

Anonymous
Not applicable

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.