Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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
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.
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 35 | |
| 34 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 99 | |
| 73 | |
| 66 | |
| 65 |