Incremental load on multiple tables

[Rajeshkumaryarl]

Hi Every one. I have a model which has multiple transactional tables and i cannot combine all transactional tables in to one trasactional tables. Is there a way we can configure incremental load in all trasactional tables ?? I am aware we can do it on one trasactional table. Can we do it on multiple tables ??

[Bipin-Lala · Accepted solution]

Hi @Rajeshkumaryarl,

Yes, it is possible to set incremental refresh for multiple transaction tables in Power BI. You just need to setup incremental refresh for each of the table individually.

I currently have a report published in our organization's tenant which has 5 large fact tables that have been set to refresh incrementally.

I would have have explained the steps here, but we already have Microsoft Documentation and many blogs, videos available, that lay down the steps required to configure incremental refresh in Power BI. Just follow the steps mentioned in the below links - 

• https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure
• https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
• https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Let me know if you have any specific questions or if you are facing any issues in setting up the refresh!