Forum Discussion
Best Approach for Incremental Refresh When Historical Records Can Be Updated
Hi v-saisrao-msft Not yet if we follow this approc then we will be refreshing the complete 7 years of data again andit will not reduce the compute cost.I am looking in to XMLA endpoint solution if it can help. Thanks
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