423
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

Hello @Steven, It has been quite some time since this idea was originally submitted in 2021. Could you please provide an update on the current status of incremental refresh support for the Dynamics 365 Business Central connector in Power BI?Many Business Central datasets, especially ledger and transaction tables, continue to grow significantly over time, and native incremental refresh support would greatly improve refresh performance and reduce resource consumption.Could you let us know whether this capability is currently available, planned for a future release, or if there are any recommended alternatives from Microsoft?Thank you for your time and support.

Category: Reports and Business Intelligence

S

Our client has 2years of financials. The refresh rate is a huge issue. This feature is past due!

Category: Reports and Business Intelligence

S

Please add this features as it will be a huge help for BC records that already reach millions of rows.

Category: Reports and Business Intelligence

S

I am eagerly waiting for this feature! Our reports are significantly slowing down due to the amount of data API loads during each refresh. This is very much needed please!

Category: Reports and Business Intelligence

S

Desperately needed.

Category: Reports and Business Intelligence

S

Either this or fabric database mirroring like on prem has the option to do

Category: Reports and Business Intelligence

S

Either this or fabric database mirroring like on prem can do

Category: Reports and Business Intelligence

S

This would be a game changer and I'm shocked it's not yet considered. The amount of data being loaded throughout the day from the APIs is unnecessary. This is something that is highly needed. Refresh times are out of control and we're only 5 months into BC. I'm scared what 12 months will look like.

Category: Reports and Business Intelligence

S

Agreed. Ultra needed.

Category: Reports and Business Intelligence

S

Very much needed. Surely would reduce significant load on Business Central SaaS platform too.

Category: Reports and Business Intelligence

  • 1
  • 2
  • 3
  • 4