I have a Power BI report running in the Power BI Service which was set up in PBI Desktop so that only one table refreshes. This table is quite large and receives its data constantly throughout the day from a PostGreSQL table on an Amazon AWS database.
I would like to automatically refresh Power BI on the Service periodically throughout the day but preferably only with data received since the previous refresh.
What would be the most efficient way of doing this?
Paul
Hi @PaulBoyes
Incremental Refresh would be the way to go
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Also a few things to keep in mind as well for refreshing and not sure if this will affect you and also is this something permanently for you or just for a time frame to check on? :
Regardless of incremental refresh, Power BI Pro datasets have a refresh time limit of two hours and do not support getting real-time data with DirectQuery. For datasets in a Premium capacity, the time limit is five hours .
Generally speaking I have always used Scheduled Refresh but most of the data I get isnāt data that is pulled from a live data source.
Hello @PaulBoyes just following up if the response above help you solve your inquiry?
Please donāt forget if your question has been answered within the forum it is important to mark your thread as āsolvedā.
Hi @PaulBoyes, due to inactivity, a response on this post has been tagged as āSolutionā. If you have any concern related to this topic, you can create a new thread.