The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 customerRecordType
Hence, 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 customerRecordType
Hence, if your change it to following, then this would work
CustomerTableType = type table CustomerRecordType