When connecting to the SQL Server database, powerapps is able to retrieve the correct tables. Only problem is that when making an connection like an dropdown ,it shows an error in viewing the corresponding data.
The following runtine error is showing:
You don't have permission to view this data.
Server response: (table.name)
failed: Permission Exception
inner exception:
Internal error: DataSourceCredentials
We are using an SQL on premise connection with a gateway and have access to both.
Anyone got pointers on how to solve this? Thanks in advance.
