https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#configure-incremental-refresh
Making incremental refresh possible, out-of-the-box, will increase the performance of the data refresh, since less data will need to be refreshed, in for example ledger entry tables.
Comments
Please implement this. In many cases I could avoid using dedicated Data Warehouse databases if incremental refresh on the dataflows was possible. There is just no point in loading millions of ledger entries multiple times per day when the actual delta is only a couple of thousand!
Category: Reports and Business Intelligence
Agreed, we are using Power BI due to limitations in financial reports/account schedules, and refreshes of millions of rows of data are taking forever.
Category: Reports and Business Intelligence
Definetely need! , when we use more powe bi reports enviroinment get slow very much
Category: Reports and Business Intelligence
We are working on financial dashboards with large data sets spanning several years. Incremental refresh would make this kind of reporting far more efficient.
Category: Reports and Business Intelligence
Agreed, this is very much needed!
Category: Reports and Business Intelligence
This would be great. Native export to data lake would be better though.
Category: Reports and Business Intelligence
This feature is very much needed, so please address this urgently!
Category: Reports and Business Intelligence
We are wondering how other teams are implementing their custom incremental refresh.
Our first thought was developing an incremental refresh with a timestamp field but we can’t find any common one in BC OData APIs.
Daily refresh of our dataset finishes with error due to the amount of data we are downloading, like invoices data or customer movs. Currently we are working with manual workaronds...
Category: Reports and Business Intelligence
I wonder, the idea is greate and if I am working in Microsoft I will implement it immediately.
How many votes are required to start?
The Odata is so slow in BC, if MS enabled the Incremental refresh, the customer will be happy.
Please consider the idea , please
Category: Reports and Business Intelligence
This is a must have
Category: Reports and Business Intelligence
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team