Skip to content

Instantly share code, notes, and snippets.

View txoof's full-sized avatar

Aaron Ciuffo txoof

View GitHub Profile
@txoof
txoof / PowerQuery_Notes.md
Last active February 28, 2024 19:24
Guide for things that can and should not be done when creating power queries.

PowerQuery Creation Notes

Notes

Returned Column References

The columns section of the XML document refer to the columsn that will be offered in the Data Export Manager screens. The text of the column name is arbitrary and can be anything, but the <column column="TABLE.FIELD"> portion must referr to a "core" table of powerschool. When in doubt, use column="STUDENTS.ID"

<columns>