FQDN Resolution to IP Address

[Peter-L]

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]

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]

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]

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]

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