How to retain user logins & passwords when migrating Azure SQL Server database via BACPAC

Question

I have a production application running on Azure with an Azure SQL Server and a SQL database inside it. In my application, all users are created at the database level with their passwords.

I need to migrate this database to another Azure tenant by exporting and importing a BACPAC file. After importing, I can see that the users are transferred, but can not log in via existing password. I suspect this is due to SID changes, which cause a mismatch between the logins and users.

How can I ensure that all users remain functional after migration without requiring them to reset or change their passwords?