Forum Discussion

Peter-L's avatar
Peter-L
Regular Visitor
9 years ago

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.
Peter-L's avatar
Peter-L
Regular Visitor
8 years ago

Ahh, I'd hoped someone had been able to write an R Script that executed a cmd line process or something.

 

I could maybe do it in powershell and insert into a DB for PowerBI to utilize but that'd just be an additional process.

mattbrice's avatar
mattbrice
Solution Sage
8 years ago

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...

 

 

  • Peter-L's avatar
    Peter-L
    Regular Visitor
    8 years ago

    Hi, thats great thanks.  I'll have a read and post back if i'm able to get something working!