Forum Discussion

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

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 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
      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...