Users not able to see/enter data in power App which is connected to SQL Server

[v-guran]

I need help.

I've built an app in the MS Pro Dev - Pre Prod environment. This app uses data from SQL Server. I've shared this app with the users and they have been given read/write access to SQL server. But they are not able to make any changes or see the data in the PowerBi file that has the Power App. Can someone suggest what is going on?

[cchannon · Accepted solution]

Does the connection reference to your SQL server have the right privs? You might have accidentally set it up with static credentials that do not have access to the SQL data.

[v-guran]

Thanks that worked! I had to change SQL connection to admin account