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?

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

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

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
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?

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

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

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

      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?