SQL Connection Problems

(0) Share

Report

Posted on by Anonymous5

107

Hello,

I'm just getting into flow and really enjoying what it can do for me and my team. Just before getting into this app, I begain using Excel Power Query to access some SQL database tables. I am able to connect to this database through Excel with no issue using simply my Windows login credentials on my company network.

I can see some great uses for comibining the two and I was thrilled to see that Flow has a connection for SQL server data. I tried to fill out the credentials in the Connection screen (using Windows credentials) but I always run into the following error:

"The caller with object id 'XXXX...' does not have the minimum required permission to perform the requested operation on connection 'XXXX...' under API 'shared_sql'.

The is clearly a permission issue and I assume I should get in touch with my system admin. My question however is how is the connection to the server using Excel so effortless whereas Flow continuously hits this wall? For reference, I have a previously set up data gateway for my "File System" connection which is working well.

I appreciated any help that can be offered here.

Categories:

Using connectors

All responses (2)

Answers (1)

Sort by

Anonymous5 107 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again,

Small update here. I was able to establish the connection by starting over and including my "domain" with username field. Now however when I try to use the Power Query action, I am met with the following:

"An exception occurred: You do not have permissions for the on-premises data gateway. Please request permissions from the owner of the gateway."

This seems strange as I am the owner of the gateway. Is there something I am missing here?
Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous5 ,

You can follow the steps provided in the link below to troubleshoot, please check these links and see if it helps:

https://docs.microsoft.com/en-us/flow/gateway-reference#troubleshooting

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot

Besides, you could try to update it to the latest version and recreate a Gateway, then recreate the SQL connection as before, and finally test if Power Query is available.

Ensure that the Gateway and connection are working properly during the test.

Please try again.