Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to run an executable, receive its standard output and use it as a 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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |