Information about VMs in Azure to Power BI

[Anonymous]

any body knows where to get information from Azure about existing VMs in my tenant(several subscriptions)? information about VM like hostname, ip(s), serial number. uuid, created by, created on, last updated by and so on? i would like to get this information to power bi. thx

[v-gizhi-msft]

Hi,

Did my last reply solved your issue?

If so, please mark it as a solution for others to see.

Thanks!

Best Regards,

Giotto

[Anonymous]

Hi, 

I was not able to verify rest api because of unsuccessfull autentication.

I got most needed atirbutes by powershell and cant spent more time on testing.

thank you for your help.

Kind regards

Jan

[v-gizhi-msft]

Hi,

You can get this by using API, see these:

How to use API:

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/ 

API:

https://docs.microsoft.com/en-us/rest/api/compute/virtualmachines/list 

https://docs.microsoft.com/en-us/rest/api/compute/virtualmachines/get 

Hope this helps.

Best Regards,

Giotto

[Greg_Deckler]

https://docs.microsoft.com/en-us/rest/api/azure/

Maybe?

[Anonymous]

I was already able to get some of those information by powershell. but still missing created by created on.

I would like to have it easily in powerBI then to use CSV 😞