Forum Discussion
Best Approach for Incremental Refresh When Historical Records Can Be Updated
I have a Power BI report that currently imports around 7 years of historical data. During each refresh, only about 1% of the records are actually updated, so I'm exploring whether incremental refresh...
Hi Mayankb024,
According to Microsoft, you can refresh individual partitions selectively, run targeted refreshes instead of processing the full table, update specific historical partitions, and adjust Detect data changes behavior.
Thank you.
Hi v-saisrao-msft Yes, I have gone through it but again it will not serve the purpose of reducing the compute cost as it will still scan the complete table. Now I am thinking to prepare the data set in S3 and connect S3 bucked to my power BI. Still analysing the cost part with this solution.
Thanks