Unanswered

How to remove unnecessary SQL connection in Power App

(0) Share

Report

Posted on by hongkong

277

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?

Categories:

Building Power Apps

I have the same question (1)

All responses (2)

Answers (0)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report

Hi @hongkong,

From the make.powerapps.com portal, click on the 3 dots just to the left of the modified column for your app --> select details --> in the top menu items select connections --> select the connection you want to remove, then delete it.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
hongkong 277 on at

Like (0)

Report

Hi Aaron,
Thanks for your response. I have removed the connection as you mentioned. However when I play the App it is still give me the same prompt up as my screenshot. If I press "Not allow" it will prompt me below warning:

Consent needed
This app uses data sources that require your consent. Refresh the page to continue using the app.

Therefore user have to press "Allow" and then a useless connection will be created.

Was this reply helpful? Yes No