Forum Discussion
intrasight
Helper IV
Helper IVhow 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) => ...
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?
MattAllington
Community Champion
Community ChampionSo 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.