My Power Apps project is integrated with Power BI and Power Automate. The project was functioning correctly until I changed the database connection. After updating the database connection, I had to refresh the connection settings and reconfigure the references in Power Automate. However, despite repointing the connection, I am still encountering the error: "SQL Server - This app needs access to this connection." I am unsure which connection is causing the issue, as I have already updated both Power Automate and Power Apps. Could the issue be related to the Power BI connection? Do anyone ever experience the same issue?
I would really go through every action in your flow and verify that you are using the same ConnectionReference (don't use a connection). Otherwise you are most likely having multiple connections and one is not included properly in the import solution.
once you flip them all over to a Connection Reference, the issue should stop
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.