10/20/2023 Update:
@Devender Bejju - I got a confirmation from product team that they have identified a bug and are working on fixing it. I do not have an ETA at this point but will keep this thread posted as soon as I hear back from the team about the fix.
But in the meantime, please use the below workaround to unblock from this issue.
Appreciate much for reporting this here.
10/15/2023 Update:
@Devender Bejju Thanks for using Microsoft Q&A forum and posting your query.
Thanks for reporting the issue, looks like an issue with Refetch from sources feature. It is not working as expected.
We have escalated this issue to respective product team to further investigate and will get back to you as soon as we have an update.
In the meantime, to mitigate the issue, please change the source dataset to a different one and do a preview and come to source settings and repoint to your actual dataset to preview the latest data from your source file (Sorry this is something not feasible but while the product team look into this issue, please use this workaround. I will also let you know if I figure out any other better workarounds).
Sorry for your inconvenience and appreciate for reporting this issue.
Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.