How to run external program from the custom connector

[PawelSow]

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? 

[artemus]

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]

Thanks, Nice to know. it saved my time.