This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 27%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL6%3C/text%3E%3C/svg%3E)
Hello,
I was looking for a way to query Azure AD objects (first use case are service principals) from an Azure Monitor Workbook (essentially the goal would be to have a dashboard to check for near expiring secrets and cross the information with Azure Resource to check unused service principals for example)
The problem i'm having is that it seems impossible to use Azure Resource Manager or Azure Resource Graph for this. I tried using a custom endpoint with an API Call but thats seems overkill and i dont want to store any token on the dashboard.
Is this something doable today ? Soon ? Forget it ?
Hi there,
Azure Workbooks can't use SPN and other AD objects. They work on top of user's session.
Custom Endpoints doesn't support auth calls per your request.
Hello Maxim,
Indeed, custom endpoint didnt work because CORS i guess.
For your first sentence, sorry, i don't get it.
Azure Workbooks have today a few datasources, and access to these datasources relies on User Permissions.
Is Azure AD Graph (Or now Microsoft Graph) not planned to be integrated on Azure Workbooks at all ?
Azure Workbooks use the user session who opens Azure Portal, Azure Workbooks use the same user tokens - there is no options to use SPN or MO as another authorization in workbooks.
AFAIK, there is no plans to support Microsoft Graph as a data source, at least the nearest time.
This can be done by having the workbook query a log analytics workspace, which is populated by Power Automate, though it may fit your definition of "overkill".