How to mix Full Refresh and Incremental Refresh on datasets that are in one Semantic Models

[ridhoaryo24]

Hi,

I have several datasets in one Semantic Models. Let's say there are the Sales (Fact) and Outstanding_Transaction (Fact). The Sales table needs to be set as Incremental Refresh. But Outstanding_Transaction needs to be set as full refresh. Is this possible to set up that way? Thank you in advance.

[Gabry · Accepted solution]

Hello @ridhoaryo24 ,

Sure, you can setup incremental refresh just for some selected tables.

Look at this for reference https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

[Anonymous · Accepted solution]

Hi @ridhoaryo24 ,

I’d like to acknowledge the valuable input provided by Gabry . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

The Select table listbox defaults to the table you selected in Data view. Enable incremental refresh for the table with the slider. If the Power Query expression for the table doesn't include a filter based on the RangeStart and RangeEnd parameters, the toggle isn't available. You can select your Sales table here.

You can also design your table to hold DirectQuery and Imported data in a single table. the DirectQuery part is to ensure near real-time data and the Imported part is to ensure the best performance in Power BI.

The hybrid table is partitioned so that its newest partition is DirectQuery from the data source and its historical data is imported into the other partitions. This is not a dual storage model. It is a table where one part is imported and one part is DirectQuery. Hybrid tables can only be applied to tables that have incremental refresh set.

For more details refer to the link: Incremental Refresh and Hybrid tables in Power BI: Load Changes Only - RADACAD

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Gabry · Accepted solution]

Hello @ridhoaryo24 ,

Sure, you can setup incremental refresh just for some selected tables.

Look at this for reference https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure