How does the shortcut handle deletions?

Hi Luigia-Costabil,

You can't delete the records  from the shortcut as we can do for the local table (If you have write permission and you perforn delete operation data will be lost from the source itself). It's readonly for migrate data across diffrent lakehouses without copy.

It's just pointer from the source (Dataverse or OneLake), as per your case you can directly create the table shortcut in any lakehosue by use the Dataverse as a source.

For more guidance you can refer
https://community.fabric.microsoft.com/t5/Fabric-platform/Can-you-please-help-me-better-understand-quot-Shortcuts-quot/m-p/3666585 

Hope this helps, Please consider as accepeted solution if helps or give some kudos.

Hi Luigia-Costabil ,

Shortcut is an independent object from the target. If you delete a shortcut, the target remains unaffected. If you move, rename, or delete a target path, the shortcut can break. 

Link for the above information

Unify data sources with OneLake shortcuts - Microsoft Fabric | Microsoft Learn

Also, specifically for Dataverse Shortcuts-they are read-only, hey don't support write operations regardless of the user's permissions. Create a Dataverse shortcut - Microsoft Fabric | Microsoft Learn

Thanks

Ati Puri

Hi Luigia-Costabil,

Can you conform if you get a chnace to the solution posted. Feel free to reach out again if still you having issues.