Export Assignment Standard Scores via PowerQuery

[jlserpe]

I am trying to export assignment standard score using a PowerQuery.   All the fields I need are in the StandardGradeScetion table which are storecode, calculatedgrade, standardid, and studentsdcid.  I need to include the assignment name associated with each score in the StandardGradeSection table.

I see that the AssignmentSection and Assignment tables have the Assignment name.  Does anyone know what tables I need to join to the StandardGradeSection table to get to the assignment name?

Thanks

[Pamela329Lac]

Hello!

To include the assignment name in your PowerQuery export, you'll need to join the StandardGradeSection table with the AssignmentSection and Assignment tables. The likely join path is:

StandardGradeSection → AssignmentSection (using standardid or studentsdcid as the key)

AssignmentSection → Assignment (using assignmentid as the key) 

[jlserpe]

Thanks for your quick response!  In the AssignmentSection table (attached), I don't see either a standardid or studentdcid to join the StandardGradeSection to.  Any suggestions what I am missing?

Thanks