When moving data from a sandbox environment to your dev-box you need sqlpackage to unpack the bacpac file to a database. This could give you an error message stating that the file contains corrupted data:
To get yourself passed this you can download the .net core edition of the SQLPackage from here:
Unzip the downloaded file to a folder of your flavor. In that folder there’s another version of the sqlpackage.exe and that should allow you to continue:
After this was posted a new bug started appearing:
The error text is:
*** Error importing database:Could not import package.
Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 102, Level 16, State 30, Line 1 Incorrect syntax near ‘type’.
Error SQL72045: Script execution error.
The solution is the same as the above mentioned but just a newer version of the SQLPACKAGE software: