how to reference named table in a query?

[intrasight]

I am migrating the standard "parameter table function" that uses an Excel workbook to instead use a named table. My table is named "Parameters". My function is:

(ParameterName as text) =>
let
ParamRow = Table.SelectRows(Parameters, each ([Name] = ParameterName)),
Value=
if Table.IsEmpty(ParamRow)=true
then null
else Record.Field(ParamRow{0},"Value")
in
Value

But this error is reported:

An error occurred in the ‘’ query. Expression error: The name 'Parameters' wasn't recognized. Make sure it's spelled correctly.

So clearly I don't understand how to reference named tables in Power Query. What am I missing?

Thanks

[pqian]

By "Named Tables" do you mean a table in your Excel workbook? PowerQuery (M language) cannot directly interact with Excel's objects. You need to import the workbook and then operate on the imported Query.

[intrasight]

Hi,

I have a query named "Parameters". It is of type "table" (has table icon in query sidebar). It was created with the new "Enter Data" feature.

Thanks,

Chris

[beedeagle]

It may recognize the query as table in M formula. Try to create another query of the current Parameters table, then name the query to "Parameters".

[intrasight]

The parameters table is a query. The query name is "Parameters". It is of type "table"

[greggyb · Accepted solution]

You should be able to make the reference as you're describing. I would double check for case and extraneous whitespace (trailing spaces are never fun). If these check out, would you be able to share a sample .pbix (hosted publicly on OneDrive or similar) that recreates the issue for us to look at, please?

[intrasight]

Ok. I'll make one from scratch and if it still doesn't work I'll post it online.

[intrasight]

The one I made from scratch worked fine. So either I had typo or I had used a reserved keyword. Where are the reserved keywords documented?

[MattAllington]

So this function references an object (table?) called Parameters. Is that loaded in your data model already?  I have never used functions in Power BI. I assume they work - not sure.