This article aims to explain how to load different Daxium elements (submissions, lists, workflows, etc...) in your Microsoft Power BI report.
Prequisites: In order to know how to set up Power BI to get data from Daxium-Air, please follow the documentation in this article
You will also need the Daxium-Air Power BI template, provided by your project manager. It contains a set of preset functions allowing you to access the data.
The following queries have to be created as a "Blank Query" & then by inputting the below code
Users & Licencing
The subscriptions of your workspace
= LoadEntityRows("subscription")The licenses of each user
= LoadEntityRows("subscription")The table of all users
= LoadEntityRows("user")The table of all groups
= LoadEntityRows("group")The groups of each user
= LoadEntityRows("user_group")