Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
6 years ago
Solved

Connecting to SQL via Gateway - Token Error

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 ...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    6 years ago

    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?

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      6 years ago

      Hi,

       

      Glad that resolved your gateway error.

       

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

       

      Thanks