cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpereiraTFF
New Member

How to filter xAPI data (JSON)

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

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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
New Member

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
Community Support
Community Support

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.

 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors