Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.