Answered

License Issue?

(0) Share

Report

Posted on by jilani_689

We have several apps in our environment where we are using premium SQL connector. However for one particular app, users are unable to access the app and license error is seen in image pops up while users are able to access other apps that has SQL connector. What could be the reason users are unable to access that one particular app?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

vaubeee 533 on at

Like (1)

Report

Hi @jilani_689 ! It's a little bit of a guessing game here 😉 You are obviously pretty confident that all users do have Premium licenses. However, it's worth to check...
Maybe the "other SQL-Apps" are build upon implicit connections which means that the user implicitly uses the credentials of the account that the app maker used to connect and authenticate to the data source during while creating the app. Power Apps SQL
Maybe this helps to further investigate ...

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

Was this reply helpful? Yes No
jilani_689 33 on at

Like (1)

Report

I did some digging and I realized in App settings, 'Per-app licenses' option was switched OFF in app settings for that particular app as seen in below image. 'Per-app licenses' setting was already ON for all the other apps. I turned 'Per-app licenses' ON for that particular app and users were able to access the app. This issue never occurred until Microsoft recently revised power apps plan which is like 20$ per month per user.

Also as far as my knowledge goes, only per user plan was assigned to developer and no other licenses were individually assigned to other users of organization and users were able to access all the apps that were shared with them.

Was this reply helpful? Yes No
vaubeee 533 on at

Like (1)

Report

@jilani_689 Happy I got you on track ! 😉 Please consider to accept my answer as a solution so other users can find it when experiencing similar issues. 👍

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

Was this reply helpful? Yes No
jilani_689 33 on at

Like (1)

Report

I appreciate your efforts taking out time and looking into issue but I believe it was not about about SQL implicit connections. We are sharing all our apps implicitly.

Was this reply helpful? Yes No
vaubeee 533 on at

Like (1)

Report

@jilani_689 That's correct indeed, but it was at least a good approach to have a closer look at the licensing of your app 😉 - Thanks!

Was this reply helpful? Yes No
jilani_689 33 on at

Like (1)

Report

Indeed. Thanks a ton!

Was this reply helpful? Yes No