323
Currently the Business Central connectors in Power BI, and Power Query, do not support incremental refresh:
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.
STATUS DETAILS
Needs Votes
Ideas 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

Comments

S

This would be a game changer for our customers and it would improve the refresh time in Power BI significantly.

Category: Reports and Business Intelligence

S

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

S

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

S

Definetely need! , when we use more powe bi reports enviroinment get slow very much

Category: Reports and Business Intelligence

S

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

S

Agreed, this is very much needed!

Category: Reports and Business Intelligence

S

This would be great. Native export to data lake would be better though.

Category: Reports and Business Intelligence

S

This feature is very much needed, so please address this urgently!

Category: Reports and Business Intelligence

S

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

S

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

  • 1
  • 2
  • 3