Forum Discussion
how to reference named table in a query?
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?
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".
The parameters table is a query. The query name is "Parameters". It is of type "table"
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?
Ok. I'll make one from scratch and if it still doesn't work I'll post it online.