Forum Discussion
Best Approach for Incremental Refresh When Historical Records Can Be Updated
Hi Mayankb024,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
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
Hi Mayankb024,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.