Avoid usage of Implicit connections to connect to SQL

(0) Share

Report

Posted on by svignesh

I am trying to use a Azure SQL MI as a backend and create a PowerApps to perform CRUD operations.

I created a Connection and used SQL User id and password to create a connection.

When I use this in the PowerApps, it says Implicit connections is being used and users will be able to use the connection is different apps and modify data.

What is the recommended way to connect to SQL from PowerApps?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

It depends on your organization and what you are trying to do. With the SQL connector there are both Implicit and Explicit connections, depending on the credentials you use to connect to SQL. The various types are explained here:

Use Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft Docs

The downside to Explicit connections is that each user who uses the app must have permissions granted in the database. You can use Implicit connections securely if you create a DLP policy that only allows the SQL connector in specific environments and then modify security in those environments to prohibit users from creating apps, other than the ones approved to use the connector. Taht way you can use the Implicit connection but regular users won't be able to create new apps that use the implicit connection unless they are on the approved list. The one limitiation is that you can't change the security in the default environment.

Was this reply helpful? Yes No
EvaSan on at

Like
a
(0)

Report
Copy link

Link copied!

Hello.
I have a problem related to this. I have an application that connects to a Sql Server database. This connection is implicit, and users access the data through my user and therefore there is a security issue that I have to resolve.
I want these users to have access with their credentials by changing the connection to an explicit type. The users already have their own database access user, but I don't know what change I have to make to the Power apps Sql Server connection to make the change go from implicit to explicit.
Can someone help me with this?

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Whether the connection is implicit or explicit is dependent on the authentication mechanism being used. This article specifies which authentication types are implicit and which are explicit. You need to switch to one of the authentication mechanisms that is explicit. Use Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No