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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
dash1
Frequent Visitor

Scheduled refresh refreshes at random times

I have a problem with the scheduled data refresh on Power BI Report Server. The scheduled data refresh does not work at the times configured. For example, when i configure a refresh for a fixed time each day or configure a refresh at every minute, Report Server refreshes only at random times. The refresh mostly happens once a day at night and not at the configured time.

 

 

 

When I click on Refresh Now the status gets stuck at Refreshing and the data won't ever refresh again. I do not see any errors.

 

 

The data sources causing the problems are Excel/CSV/TXT files on network drives. The connection from the Report Server to the data source is successfull and so is the data refresh in Power BI Desktop. SQL Server databases also work as source.

Only the scheduled data refresh for Excel/CSV/TXT on network drives does not work.

 

 

Any ideas? Thanks in advance

1 REPLY 1
jpnayak
Frequent Visitor

I have the same issue in Power BI report server Aug 2018. All newly created schedules are stuck in "refreshing" and previously created jobs stopped at "completed data refresh". I have no clue why did it happen, I checked logs ,event viewers and Reportserver database SubscriptionHistoryID table etc. but got no luck. It is just idle, nothing happens. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.