Data and Analytics Group

abunag · 2025-04-01

Anyone had any success with integrating Canvas with PowerBI? Our analytics team would like to be able to grab info out of Canvas easily. Thanks!

mcarruth · 2025-03-20

Is the data from New Quizzes available in CD2? If so, in which table(s)?

marcinbunsch · 2025-03-20

When using Data Services, you can choose to have the request signed and get a JWT payload.However, Canvas Data Services still sends the request with "Content-Type: application/json", whereas it should be "Content-Type: text/plain".Canvas Data Service...

AlexJackson · 2025-03-19

I recently (18 March 2025) started getting a typing error when fetching jobs from snapshot queries using the python client library. I haven't changed anything since I started getting this error, so I'm inclined to believe there is an issue with the t...

IWCC_MTC · 2025-03-18

It occurs intermittently during individual table syncs. 2025-03-11 06:15:19,229 - DEBUG course_account_associations table has been updated 2025-03-11 06:54:49,916 - DEBUG enrollments table has been updated 2025-03-11 07:33:28,644 - DEBUG course_sec...

RachelR1 · 2025-03-06

Hi all, Hoping someone can assist. I am currently working on identifying a assignment due date at an individual student level. When there are multiple overrides set I am having trouble figuring out which override(s) take precedence. Example: a studen...

MiguelMontanez · 2025-03-05

Hi, Is there a way to generate the time students spend in Canvas on a weekly basis? The total time is available under the "People" menu; however, I would like to have a summary of time spent and number of logins on a weekly basis. I explored the "N...

jasonunf · 2025-03-04

Hello, Does anybody know how to set up a custom location for the files downloaded by the dap? Basically need to setup the temporary folder in a much larger drive, instead of the dap using the windows default temp folder for each user. I'd like to cha...

mclark19 · 2025-03-03

@sgergely It seems that schema versions for a number of tables in the the canvas namespace have reverted. For example, "rubrics" had been at version 2 in mid February, but shows version 1 when downloaded today from DAP. The following tables seem to h...

mclark19 · 2025-02-28

We recently did a new snapshot of our catalog tables and noticed that the enrollments table contained duplicates of most records. Other tables seemed OK. Has anyone else noticed duplicate records in snapshots? Thanks.

reynlds · 2025-02-28

I'd like the details of these elements to understand what it means and how it's calculated on this API endpoint: https://canvas.instructure.com/doc/api/analytics.html#method.analytics_api.course_student_summaries

kdoherty2 · 2025-02-27

Has anyone experience this issue? When we run syncdb to refresh our CD2 enrollments table to postgres, the process hangs and does not finish. All other tables sync successfully. Some enrollments data are being loaded to the database. We can confi...

nicki_alori · 2025-02-26

Hi everyone  Im hoping someone else out there has found a way to resolve this challenge.... Problem definition: We use assignments with rubric assessments for grading, but we want to have visibility of the movements within the rubrics so it is easy ...

jasonunf · 2025-02-20

HI, I'm looking to migrate our CD2 setup from postgres to MSSQL and I'm running into an issue. Does anybody have information on properly setting the DAP for MSSQL server? I'm not finding any information beyond the basic connection string used and i'm...

RachelR1 · 2025-02-18

Hi all, Can someone please help me understand what the Assignment_Overrides.Set_Type = 'Noop' means? I can't seem to find any documentation on it. Thanks all  Rachel

Adamleighton · 2025-02-13

I need to implement an attendance monitoring system that triggers alerts when a student's attendance rate falls below 85%. However, to avoid false alarms at the start of a course when the sample size is small (e.g., missing 1 out of 2 classes would s...

AndreDhondt · 2025-02-12

When running the following from the command-line, I get an error that prevents me from synchronizing the collaborations table: >dap initdb --namespace canvas --table collaborations 2025-02-12 14:16:09,376 - INFO - Query started with job ID: 5bb1d1c0-...

morgan_j · 2025-02-11

Wondering if anyone would be willing to share how they might be forwarding Canvas activity logs to an external logging system (Splunk or syslog)? More specifically, how you are getting analytics out externally to see student activity logs of assignm...

RachelR1 · 2025-02-06

Hi all, I am needing to identify the students who have access to a discussion, page/wiki or module via CD2 when access has been limited to certain sections and or students via the 'Assign Access' feature. Is someone able to help point me in the right...

DanL · 2025-02-06

After updating to the latest and greatest Canvas Data 2 dap client cli version, I notice the dap_meta table (which stored the timestamps of when all the tables were last updated) seems to have been renamed to dap_meta_backup, and there is no replacem...

RachelR1 · 2025-02-04

Hi all,I am trying to figure out how to identify if an assignment grade is visible to a student (posted) using CD2 data.The submissions table workflow state only has a 'graded' state but that doesn't identify if it is available to students.Any help w...

gwwitte · 2025-02-03

Hello, My institution is trying to identify students who have not accessed their online courses through Canvas in the first two weeks of class. Looking at the data tables on the DAP ERD it seems like canvas.asset_user_accesses likely has the data I n...

cdellapietra · 2025-01-31

Hi All,Our group noticed a few tables producing error messages with the updates to the enumeration types recently. Upgrading the DAP client to the 1.3.1 didn't seem to fix the problem with the enum type update, but I did notice a change in the syntax...

CBCDeveloper · 2025-01-28

Is there any way to get the "Course Audit log" Published dates from the Canvas database?Problem: It seems like currently the only way to get this information is from the Course Audit log API command.Background: A dean wants to be able to run an SQL r...

JasonBrandt · 2025-01-24

We are using the new DAP 1.3.1 client. We perform a database initialization. The API runs fine for all tables until we get to the assignments table. Every single time we are receiving the same error regardless of what we do: File "C:\Users\jbrandt\...

reynlds · 2025-01-22

Got this little ditty today: 2025-01-22 10:05:05,294 - ERROR - malformed HTTP response:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/htm...

marco_divittori · 2025-01-15

Anyone know which table contains records about Global Announcements? Thanks!

pgo586 · 2025-01-13

I've been using Canvas Live events (Caliper format) to find instances of files being downloaded in Canvas courses. However, recently it's come to my attention that these events may refer to files with names that do not exist as such within the cours...

willmoin · 2025-01-13

Hi Everyone, One of our school admin team contacted us. She noticed that the New Analytics>LateAssignments reporting generates a time/date format that our setup of Excel does not immediately recognise. E.g. this is the result: Submitted DateGraded...

AndreDhondt · 2025-01-09

We've been cloning Canvas data successfully for months using DAP2, but recently noticed this sync failure, which looks to be coming from DAP code. When I run this directly in a query editor it balks at the newline separators and the quotes as well as...

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Integrating Canvas with PowerBI?

New Quizzes

Data Services sends incorrect Content-Type when request signing is on

CD2 Python Client Library Typing Error

Getting aiohttp.client_exceptions.ServerTimeoutError: Connection timeout to https://api-gateway.inst...

CD2 - Assignment Override Precedence

New Analytics; Time Students Spend in Canvas (on a weekly basis)

Canvas Python DAP, custom TEMP FOLDER location

Canvas Data 2 schema version errors

duplicates in Catalog enrollment table snapshot

participation_level/page_views_level for course-level participation???

Canvas Data 2 syncdb not updating meta-data

Historical data of assessment decision when using rubric assessments for grading...

basic MSSQL database configuration

CD2 - Assignment Override 'Noop' Set Type?

Roll Call Attendance / Grades Alert

DAP initdb error: expected UUID

Forwarding Canvas Activity Logs Externally

CD2 - how to identify which users / sections have access to page or discussion

dap_meta - where did it go? Canvas Data 2

CD2 Identify if a assignment grade is visible to student

Student user accesses

Canvas Data 2 Postgres Error with Enum Types

Course Audit log Published Dates from Database

Please Help: SQL Server Support error persists

More CD2 errors happening lately...

Global Announcements

curiosity within Canvas Live Events - can you help explain it?

Date format of New Analytics lateAssignment report not interpretted by Excel correctly

DAP Canvas Data 2 replication error--invalid syntax

You're signed out

Data and Analytics Group

Data and Analytics Documentation

Data and Analytics Group Discussions

Community Help

View our top guides and resources: