PowerBI Report Server Schedule Refresh status Refreshing Forever

[ramonivandy]

I have schedule refresh every 1 minute. When I use Refresh Now, the status changing to Refreshing. After waiting for a hour, the data not updated and the status keep refreshing forever. 

 Searching for error message but found nothing, any advice? 

[Anhsang84]

Hi, I met the same problem.

So, what is the root cause of this issue?

Who knows the answer please share it with me.

Thanks

[josef78]

I don't recommends schedule refresh every 1 minute, I recommend 5min at least, or use direct query.

But for check state of refresh, lookup in to table SubscriptionHistory (and related tables Subscriptions, Schedule and ReportSchedule) on MSSQL ReportServer database. Or use rest api to check refresh state.

[ramonivandy]

Hi @josef78 

PowerBI RS did not support Direct Query to PostgreSQL for now, so I need to refresh every 1 minute to get real-time data. 

I found a similar question and solved it by scaling out the server. Is scaling out the server the only way to solve this?

[josef78]

Yes, independly on this topic, for production deployment (except very small deployment) I can recommend scale-out deployment, and additionally setup role for each server, if it is front end server or it is background processing server.

But back to your problem... simulate realtime/direct access by procesing tabular model every minute, I think is not good way. I'm not sure, but very short bias will be problematic (due async start from sql agent schedule). You can try set 5min interval, and after try lower to 4,3,2,1 minute, and check reliability. But better way should be move to SSAS model, where you have much better control above processing (including different processing modes), and maybe direct query support (I'm not sure for progressql or odbc sources).