Hi @rajanisqldev-42 ,
Thank you for posting query in Microsoft Q&A platform.
Unfortunately I don't have dataverse environment to repro. But I can say that you may need to query snapshot data to avoid above error.
Kindly check below link. Where it explained that snapshot data will be available under each table folder and snapshot folder. Kindly check snapshot data
section from below blog.
https://www.taygan.co/blog/2022/06/28/azure-synapse-link-for-dataverse
Hope this helps. Please let me know how it goes.