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.
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Peter-L,

 

Based on my research, it's not supported to resolve the FQDN to corresponding IP address in Power BI currently.

 

Best Regards,
QiuyunYu

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

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