Forum Discussion

intrasight's avatar
intrasight
Icon for Helper IV rankHelper IV
10 years ago
Solved

how to reference named table in a query?

    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) => ...
Need Help
  • greggyb's avatar
    greggyb
    10 years ago

    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?

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    intrasight
    Icon for Helper IV rankHelper IV
    10 years ago

    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