cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shark1986
Frequent Visitor

Connecting to on premise SQL with Powerapps: you don't have permission to view this data

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.

 

 

 

 

4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

Viewing the tables available requires permissions to the Master table in SQL, but viewing data inside the table requires permission for that table.  Check to make sure the account you used for the connector has permissions for that specific table inside SQL on-premises.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Unfortunately this shouldn't be the problem. The SQL connector has permission to view the data in the tables as well. The tables were made with the same account that is connected to the PowerApp. Could it be something in the gateway settings?

Pstork1
Dual Super User III
Dual Super User III

There's nothing in the gateway settings that would affect this as far as I know.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Shark1986
Frequent Visitor

I checked all the settings, but eventually deleting the connection and setting it back up, did solve the problem.

Editing the connection did not unfortunately. Thanks for all the suggestions. 

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (34,905)