Forum Discussion
PowerBI Report Server Schedule Refresh status Refreshing Forever
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?
Memorable MemberYes, 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).