cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amin4000 Occasional Visitor
Occasional Visitor

Standard output as data source?

Is there a way to run an executable, receive its standard output and use it as a data source?

3 REPLIES 3
Super User
Super User

Re: Standard output as data source?

I would have a look at Power Query's accessing data functions and R. 

https://msdn.microsoft.com/en-us/library/mt296615.aspx

 

I have to believe that this would not be supported by any gateway however. Seems like an awfully big potential security risk.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


hugoberry Member
Member

Re: Standard output as data source?

Following @Greg_Deckler advice here is an R based solution.

 

let
dummyInput = #table(null,{{1}}),
RScript = R.Execute("output <- dataset#(lf)output$system <- system2(""whoami"", stdout=TRUE)",[dataset=dummyInput ]),
output = RScript{[Name="output"]}[Value]
in
output

Super User
Super User

Re: Standard output as data source?

Nice. Have you tried that in conjunction with an on-premises gateway? Just curious if it would work. Obviously, the cloud gateway is not going to support any random executable but would be interesting if the on-premises gateways did.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!