How to copy a database to another server with only some of the rows

Trying to copy a database from a hosted server to a local server for testing purposes and am trying to avoid exporting the whole database as a .bacpac file as there are some tables with tens, maybe hundreds of thousands of rows. I've tried looking for ways to export the database as a .bacpac file using only the top X rows of each database without luck. I have similarly had little luck with exporting the database as a .dacpac file and then transferring a select amount of data between the hosted and local servers.