How to filter xAPI data (JSON)

[mpereiraTFF]

Hello,

I am wondering how I can filter xAPI data that is in JSON format. An xAPI statement contains an actor, verb and object. See here: https://xapi.com/statements-101/

There are optional fields like "Results" that can be used to store how a user/learner answered a question. Below is a link to a xlsx file with example data. I want to be able to add multiple filters to see how users/learners answered.

https://www.dropbox.com/scl/fi/wznnjeb56u8c8kwuqij1e/xapi-example.xlsx?dl=0&rlkey=kk5op69xth9vw4avr5...

Example:

How many learners answered "A" for question #2 that answered "B" for question #3. The issue when filtering is that learner response for all questions, in this case, questions #2 and #3 are all in the same column. I have worked around this by summarizing tables to get the actor and response then filter the summarized table to only see the results for question #3. This allows me to use slicers, but is very inefficient. We want to be able to filter on all of the data. Is there a better way to achieve this? How have others solved this challenge when working with JSON data?

Thanks in advance for all of the help!

-Matt

[v-yalanwu-msft]

Hi, @mpereiraTFF ,

Perhaps you can use RLS to filter each user at the row level.

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mpereiraTFF]

Thanks for sharing those links. However, they don't solve my problem. I don't have any issues getting the data into PowerBI, the issue I am having is filtering data because, all of the data is in the same column in powerbi. I want to be able to create reports that allows users with limited PowerBI knowledge to filter the data on all of the possible responses. I can filter using DAX, but I want users who are not familiar with DAX the ease of filtering data.

I am currently building additional tables for every result i want to filter on, which is time consuming. Ideally, there would be a function that could see all of the results and labels that go with the results, that I could use to filter against.

Thanks again,

-Matt

[v-yalanwu-msft]

Hi, @mpereiraTFF ,

You can check if these related post can is useful to you.

https://extended.traxlrs.com/docs/2.0/extended-api

https://docs.learninglocker.net/http-xapi-statements/

https://help.openstreetmap.org/questions/39026/json-from-a-xapi-query

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.