Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hey All,
I was watching this great lesson , "
and at around the 29th minute of the video, the presenter shared a code for user-defined types as below :
let
CustomerRecordType = type [FirstName=text, LastName=text],
CustomerTableType = type table customerRecordType,
CustomersTable=
#table (CustomerTableType,{
{"Matt", "Masson" },
{"chris", "webb" },
{"Reza", "Rad" },
{"Chuck", "sterilicious"}
}
)
in
CustomersTable
But when I am running the code in PQ, verbatim as shared, I get the following error :
Any idea why I am getting this error instead of the table and shown in the output in the lesson? Am I missing something?
Thanks and really appreciate the help.
Solved! Go to Solution.
PQ is super sensitive to case. This line has customerRecordType which should have been CustomerRecordType (i.e. small case c should be replaced with C).
CustomerTableType = type table customerRecordTypeHence, if your change it to following, then this would work
CustomerTableType = type table CustomerRecordType
PQ is super sensitive to case. This line has customerRecordType which should have been CustomerRecordType (i.e. small case c should be replaced with C).
CustomerTableType = type table customerRecordTypeHence, if your change it to following, then this would work
CustomerTableType = type table CustomerRecordType
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 7 | |
| 4 | |
| 3 |