Forum Discussion
FQDN Resolution to IP Address
Hello, I'm new to Power BI / R Scripts and was wondering does anyone have any ideas or pointers on how I can take an FQDN column and resolve it to its associated IP Address? Thanks, P.
Funny as i just happened to be cruising around this morning and ended up on the excellent BICCOUNTANT website, and she referenced another articel about Power Query/ R script and things that can be done and i saw this:
https://querypower.com/2017/03/11/r-execute-the-swiss-army-knife-of-power-query/
In the back of my mind i thought of this post while reading. If you look at the last section, it does just what you mentioned about running a cmd line process. You should be able to run nslookup or dig or equivalent and parse the results.
Hope this helps...
Hi, thats great thanks. I'll have a read and post back if i'm able to get something working!