Show licenses overview on Azure Workbooks

Question

Hi,

I would like to add the following Graph query:

https://graph.microsoft.com/v1.0/subscribedSkus?$select=skuPartNumber,consumedUnits,prepaidUnits on an Azure Workbooks. Is there a way to show missing licenses on a Azure Workbooks.

Thanks

Answer 1

Hi Marino Valentino, thanks for answering my question.

If I understood you correctly, you want to create an Azure Workbook that requests data from the mentioned Microsoft Graph endpoint and displays it in the Workbook.

Unfortunately, this is not currently possible because Azure Workbook does not have an OAuth function to query the Access Token. A one-time creation of the Access Token would be possible with an AzureAD Enterprise App but makes no sense as I assume you need live data which is only possible with an OAuth lifecycle in the background.

---

If the reply was helpful, please don’t forget to upvote or accept it as an answer, thank you.

Answer 2

This can be done by having the workbook query a log analytics workspace, which is populated by Power Automate.