Accessing your Data in Power BI

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")

Forms, Submissions & Lists

• The forms of your workspace

= LoadEntityRows("structure")

• All submissions (common data)

= LoadEntityRows("submissions")

• All tasks

= LoadEntityRows("task")

• All Lists

= LoadEntityRows("list")

• Submission History

= LoadEntityRows("submissions_history")

• All Relations

= LoadEntityRows("submissions_relation")

• All workflows

= LoadEntityRows("workflow")

• Submissions from a specific form. Here the id should be the one of your form. You can find it either in the URL of your form, or in the "structures" table

= LoadFormRawRows(id)

• One specific list. Here the id should be the one of your list. You can find it either in the URL of your list, or in the "list" table

= LoadList(id)