Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 8 | |
| 7 |