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: 934
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 Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests