Forum Discussion

PawelSow's avatar
PawelSow
Frequent Visitor
6 years ago

How to run external program from the custom connector

Hi

 

I am brand new for Power Query. I try to write custom connector. It will have to create a authorization token and insert it to the http header. Token generation is quite complicated operation so I would like to do it in separate console application. Is it possible to execute external program from the custom connector power query? 

 

2 Replies

  • artemus's avatar
    artemus
    Microsoft Employee

    I'm afraid that is not directly possible (security model and whatnot) . If only one entity will import data you can use a personal gateway to do the authentication, or simply set up your own pass through server.

     

    Is there some part of power query you are unsure how to do a certian type of operation? 

    • PawelSow's avatar
      PawelSow
      Frequent Visitor

      Thanks, Nice to know. it saved my time.