Private links are currently not supported with elastic query for those databases that are targets of external data sources.
Source: Elastic queries preview limitations.
You may want to consider then use SQL Data Sync to sync data between the 2 databases. Please read here if SQL Data Sync can help you as a workaround.