I'm looking for the best way to extract all user quiz responses across my entire organization.  For example, I have a post-course survey that collects feedback in the form of multiple choice questions and essay questions.  I want to see the individual user responses per user and course.  I've tried using  {{domain}} /api/v1/courses/:course_id/quizzes/:quiz_id/submissions/:id/events and  {{domain}} /api/v1/courses/:course_id/quizzes/:quiz_id/statistics to pull info out but it seems like there must be a better way to get to this data.  Any help would be appreciated, thanks! ... View more

In case you missed the Instructurecon Canvas Data 2 presentation:    https://vimeo.com/625100989 What to expect ... View more

Hi I am very new to using Power BI, I am keen to build some LMS analytics in Power BI.  Would anyone be kind to sample templates or direct me to where I can find some to work with? Many thanks. ... View more

The same question was asked three years ago but I can't find a good answer. I can't  retrieve   grading_period_fact ,  grading_period_score_fact ,  grading_period_dim ,   grading_period_group_dim ,  grading_period_score_dim  tables from Canvas using API call. Is this something to do with the account I use or these grading tables are protected and cannot be retrieved? ... View more

Our institution is wanting to take a look at Canvas Data to see what kind of information we can pull out of it. I have looked around the Canvas community quite a bit to learn more about the data portal and what it offers. I have seen how to download and sync data with the Canvas CLI tool, and it seems straightforward. I do have a few questions though to help us get moving forward. With the CLI tool, does it append the new data from the previous day to the tables, or does it override the old tables with new tables? How do I get all historical data? Has anyone tried to automate an import into a database running MS SQL? If this isn't a good option, then what would be a good alternative? We are wanting to us MS SQL because that is what we are used to using.  Thank you for your help? ... View more