At the beginning of building my canvas app, I connect to my datasource (SQL Server) using AAD. Later, I create a new connection with SQL authentication. Then switch all my datasource to the new connection in the App studio.
However, by some reason, every user opening the App will be asked to provide access to 2 connections (as show below). One is my old connection type using AAD. Another is SQL authentication connection. It is annoying because all my users do not have AAD access to the SQL server. How can I fix it?
