cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.