Thanks @yashag2255 for your reply, it's worked for me but I have an issue
There is a field in entites called owner I use owner to set permissions and privalages
in sql there is a field contains user_Id, I can map user_id to email but I can't migrate owner field
I'm completely new to CDS, but this doesn't appear to be do-able if you are using a On-premise Data Gateway?
I am finding it a bit unbelievable and hoping I'm just wrong because PowerApps, Flow, PowerBI is all built around CDS from my understanding, seems silly if all these can talk to a data gateway but CDS itself cannot get data from one!
Did I miss something?
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights