The Azure ARM Virtual Machine Hours report is dependent on direct access via the SP to the Virtual Machine & the following job that executes daily:
The Azure ARM Virtual Machine Hours Report can display with no data for the current month as per the below:
There are a number of common causes for this issue:
1. Confirm that there are active Virtual Machines appearing under Assets -> Azure -> Virtual Machines we require access via the SP in order to pull back Instance hours.
2. A difference in the count of active Virtual Machines versus the count of Virtual Machines in the Azure AM Virtual Machine report can again fall down to a lack of access to all Virtual Machines.
3. Confirm the Subscription the Virtual Machine(s) that aren't appearing in the ARM Virtual Machine report belong to, isn't currently derived