255
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

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

S

This is a must have

Category: Reports and Business Intelligence

S

I keep wondering why this doesn't have thousands of votes...


Currently all the data sets of all the PBI reports need to re-download all the data over and over again every time they refresh. Having a possibility to use incremental updates would definitely have a significant impact on reducing load on the cloud servers.


THIS is a HUGE blocker for the Onprem customers that are considering SaaS BC.

Category: Reports and Business Intelligence

S

It's not great having to wait 90 minutes for the dataset to reload when I add a column to a query. "Yes, I added that new column to the item record, but you have to wait while Power BI redownloads our 500,000 invoice lines before you can use the report."

Category: Reports and Business Intelligence

S

Definetely a must have !

Category: Reports and Business Intelligence

S

Definitely a must have. Full sync is a drag.. And manual workarounds not optimal

Category: Reports and Business Intelligence

  • 1
  • 2