Answered

SQL Permissions?

(0) Share

Report

Posted on by jstraumann

Hello all:

I am messing with a Canvas Power App that uses SQL Connections. When I run the App I get the prompt shown in the attachment, but I cannot Allow the connections. How do I enable the connection so I do not get that prompt any more? Thanks!

John.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The SQL connector can be either Implicitly shared or Explicit. If its implicity shared you won't get prompted and it will use whatever credentials are embedded in the connection. To share the connection Implictly you need to use either SQL or Windows credentials.

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

Was this reply helpful? Yes No
jstraumann 39 on at

Like (0)

Report
Copy link

Link copied!

Thanks! I don't see the Data Nav Item?

Was this reply helpful? Yes No
jstraumann 39 on at

Like (0)

Report
Copy link

Link copied!

I have been creating the App from an account I *thought* was an Admin, and I did the Data connector in the App. I logged in with my global admin account, and created the connectors I need with implicit permissions, and then in the App used those instead of the other connections, and that fixed it.

Was this reply helpful? Yes No