Permissions popup for embbeded Power App

Question

Hi,I have a Power BI report with a Power Apps embbeded on it, and that&nbsp;Power App has a SQL Connection.I followed this reference architecture:&nbsp;Power BI data write-back with Power Apps and Power Automate - Azure Architecture Center | Microsoft LearnMy issue is that sometimes when i open the report, i get the following popup asking for permissions to the SQL connection:How can I avoid this popup from appearing? I already Allowed multiple times.Thanks in advance 🙂

anonymous · Accepted Answer

Hi,&nbsp;jparrrod&nbsp;Thanks for reaching out to the Microsoft fabric community forum.
Regarding the issue you raised, my solution is as follows:
1.First, please ensure that the SQL connection embedded in the Power App is correctly configured and that all users have the appropriate permissions to access the SQL database. You can check the SQL connection settings in Power Apps to make sure they are correct.
&nbsp;
2.Secondly, you can try using secure implicit sharing connections. Below is a screenshot from the relevant documentation:

For more details, please refer to the documentation.
Overview of connectors for canvas apps - Power Apps | Microsoft LearnUse Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft LearnConnect to SQL Server from Power Apps overview - Power Apps | Microsoft Learn&nbsp;
3.Lastly, if you need more detailed assistance, I recommend visiting the following link to seek help in the relevant forum:Find Answers | Microsoft Power Platform Community&nbsp;
&nbsp;
Thank you for your understanding and support.
&nbsp;
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Permissions popup for embbeded Power App

2 Replies

Related content

USER Permissions

Folder Permissions

Fabric permissions framework

Fabric permission issue

Permissions in all workspaces