Expression.Error: The name 'GetData' wasn't recognized.

Posts: 3
Joined: Tue Feb 07, 2017 4:13 pm

Expression.Error: The name 'GetData' wasn't recognized.

Postby tamiri » Thu Jun 08, 2017 4:23 am


I am trying to follow the instructions given by Matt Masson ( and wrote so far the following code:

Code: Select all

let    Source = {1..22},   

#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),   

#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Page"}}),   

#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each GetData([Page]))

in    #"Added Custom"

I get the error:

Code: Select all

"Expression.Error: The name 'GetData' wasn't recognized.  Make sure it's spelled correctly."

Can anyone advise?



Posts: 922
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Expression.Error: The name 'GetData' wasn't recognized.

Postby MattAllington » Thu Jun 08, 2017 4:28 am

GetData is a name of a function that Matt Created. Have you created a function called GetData?
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests