Hi, has anyone successfully used SQL Server – Microsoft Entra ID Integrated authentication with environment variables in a Canvas App?
We can connect and load data when manually entering the server and database, but environment variables for server/database do not resolve correctly:
- The connection dropdown becomes blank
- Database environment variables fail with “no database can be found”
This works fine with SQL Authentication, but seems unsupported with Entra ID Integrated auth.
Has anyone been successful in using SQL Server - Microsoft Entra ID Integrated Connection to add data to their Canvas App via Environment Variables? Or have any suggestions for us?
NOTE: We have tried creating a connection reference hoping that it will appear as an option when we Add Data to the Canvas App, but no luck with that.