The template now contains a GitHub Actions workflow that you can use to start building and testing your SSDT solution with GitHub Actions.

There have been a couple of fixes in the Azure Pipelines to smooth out the process

Production ready template for creating SSDT project with the PSModuleDevelopment PowerShell module