Refresh a table in power bi without refreshing the data in it;s clone/copy?

[arifshah]

We have a situation where a table full data is replaced during data refresh. We would like to compare the refreshed data with the previous data that it held. One option that I thought of was to clone the table and then refresh the original table. However, refreshing the original table also refreshes the data in the clone.

Is there any other way that the original table is refreshed without refreshing the clone/copy table?

Another solution I thought of was to use SSAS and create two tables on top of the source. This way each table can be processed individually. However, in this situation, SSAS is not an option so is it possible to do this within Power BI?

[v-easonf-msft]

Hi, @arifshah 

In PQ, you can disable ‘Include in report refresh’ for the clone table.

In this way, the clone table will not be updated the next time the report is refreshed.

Best Regards,
Community Support Team _ Eason

[arifshah]

Hi,

Many thanks for your reply. Is it possihble to schedule a separate refresh for the clone table?

[v-easonf-msft · Accepted solution]

Hi, @arifshah 

Scheduled refreshes will update the full dateset. Currently, it is difficult to configure individual scheduled refresh for  a specific tables in dataset. 

If your workspace is assigned to a Power BI Premium Capacity or Premium Per User, you can consider using the XMLA endpoint programmatically to refresh just one table in a dataset.

Rleated thread：

https://data-marc.com/2021/02/18/trigger-a-single-table-to-refresh-in-the-power-bi-service/ 

Best Regards,
Community Support Team _ Eason

[SivaMani]

@arifshah, Check out the incremental refresh - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview