How to Retain User Logins & Passwords When Migrating Azure SQL Database via BACPAC

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 an issue in login with the same password for a user.

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

Any guidance would be greatly appreciated!