Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.