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?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!