Answered

Connecting to SQL via Gateway - Token Error

(0) Share

Report

Posted on by Blair24

Hey Folks,

Getting the following error when trying to connect to an on prem SQL connection via the gateway.
The gateway is up and running, Power BI and other PowerApps/FLows are connecting to it fine but when I try to create this new flow I get the following error - not something I've came across before...?

Categories:

Using connectors

All responses (3)

Answers (1)

Sort by

Verified answer

abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Blair24 ,

This might be useful

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Problems-when-trying-to-Mark-an-email-as-read/td-p/117506

Thanks
Blair24 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @abm,

That seems to work - thanks!
Got a second error now, I know Flow & PowerApps requires SQL to have a primray key - which this table has, but Flow is stating that it doesn't, have you came across this before?
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Glad that resolved your gateway error.

Could you post a screen grab of your flow and error?

Thanks