Permissions popup for embbeded Power App

[jparrrod]

Hi,

I have a Power BI report with a Power Apps embbeded on it, and that Power App has a SQL Connection.
I followed this reference architecture: Power BI data write-back with Power Apps and Power Automate - Azure Architecture Center | Microsoft ...

My 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]

Hi, @jparrrod 

I am glad that my answer could help you, and I appreciate you accepting my answer as the solution. This recognition of my efforts also helps others in the community with similar issues find solutions more quickly.

If you encounter any problems in the future, feel free to share them again.

Have a great day!

Best Regards,

Leroy Lu

[Anonymous · Accepted solution]

Hi, @jparrrod 
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.

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 Learn
Use Microsoft SQL Server securely with Power Apps - Power Apps | Microsoft Learn
Connect to SQL Server from Power Apps overview - Power Apps | Microsoft Learn
 

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
 

Thank you for your understanding and support.

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.