Unanswered

How to use the app for users without database permissions

(0) Share

Report

Posted on by Hao_ Microsoft Employee

I created a Power App, which including kusto(Azure date explorer) connections, the connection was created by my AAD account. I want to share the app to other users, but they don't have the permission to access the backend kusto. What should I do to let these users using the app normally? Is it possible to create a kusto connection with a public account (like service principal) in Power Apps?

the connection:

Thanks a lot!!!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Hao_

As per my knowledge, Not possible to connect using the Service principle for now. Create an AD Account which is a Non-interactive account (Service Account) and use that account to connect the Data Explorer.

Thanks,
Stalin - Learn To Illuminate
Hao_ Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi StalinPonnusamy,

Thank you very much for your answer!!!
But I'm a new user of Power Platform, I still have some questions:
How can I create a service account? We have an app account in azure data explorer as following shown, is it usable?

When I try to create a new connection in power apps, the power app will directly use my login account to create a connection, and will not even let me choose or setup, what should I do to swap the account?

Best wishes
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
1. Create a regular user in AD but disable the logins since the connector is accepting App registration.
2. Once connections are created, we can change the connection using Switch Account
Go to make.Powerapps.com
Expand Dataverse on the left navigation
Click "Connections"
Find the Azure Data Explorer connection
Click 3 dots to switch account

Some information about Non-Interactive users

Thanks,
Stalin - Learn To Illuminate
Hao_ Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is indeed a good way, but it's impossible to create a new account right now, so is there any other way?
I find that we can use service principal connect to Kusto in automate flow, I try to use the flow query data and response the record to PowerApps, but it doesn't work: the user still has to be granted kusto permission…😫

Thanks