web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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.

 

 

 

 

I have the same question (0)
  • Pstork1 Profile Picture
    68,676 Most Valuable Professional on at
    Re: Connecting to on premise SQL with Powerapps: you don't have permission to view this data

    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.

  • Community Power Platform Member Profile Picture
    on at
    Re: Connecting to on premise SQL with Powerapps: you don't have permission to view this data

    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 Profile Picture
    68,676 Most Valuable Professional on at
    Re: Connecting to on premise SQL with Powerapps: you don't have permission to view this data

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

  • Community Power Platform Member Profile Picture
    on at
    Re: Connecting to on premise SQL with Powerapps: you don't have permission to view this data

    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. 

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.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics