Jump to content

Deep dive: Aggregate questionnaires via Power BI template

From Resco's Wiki
Warning Work in progress! We are in the process of updating the information on this page. Subject to change.

In this guide, we will demonstrate a prebuilt Power BI template for deserializing questionnaire answers. Questiannaire answers are inherently stored in the resco_serializedanswers columns in JSON format. To use this data in external reporting tools, we need to deserialize it back into a structured format.

In [link to deep dive], we deserialized JSON manually using Power Query. In this guide, we will use a Power BI template. Power BI templates are pre-built templates that usually include parameterized imports, Power Query, and visualizations. Templates are used as an industry standard for report distribution.

Download Power BI templates

For your convenience, we provide two templates depending on your storage entity:

  • questionnaires
  • questionnaireanswers

About the template

There are two options for processing questionnaires. Both are defined using parameters and their combinations.

As soon as we open the template, the initial parameters are to be queried.

Mandatory parameters
  • OrgUrl - clean Environment URL to which you want to connect (no https:// or tailings .../).

If only the OrgUrl param is defined, all questionnaires are queried and deserialised.

Optional params
  • TemplateID -
  • Questions -
  • TemplateA -

[tbd]

Retrieved from "https://wiki.yourdomain.com/index.php?title=Deep_dive:_Aggregate_questionnaires_via_Power_BI_template&oldid=13440"