Forum Discussion

project101's avatar
project101
Frequent Visitor
4 years ago

slicer paramter error m query

Hi

i have an error by using paramter in slicer with m query

steps 

 adding paramter

 adding filter to a table with paramter

Assigning a parameter to a field in a table that specifies the value of 

 

in  m query

----------------------------------------------------------------------

let
Source = Sql.Database("BEN-LP\HAVSQL17", "havreports"),
dbo_tbl = Source{[Schema="dbo",Item="tbl"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_tbl, each [n] = Parm)
in
#"Filtered Rows"

------------------------------------------------------------------------

Changing the value of the parameter in the paramter edit mode is by change the filter 

 

error :

the slicer  that hold the paramter create an error on the filter table 

--------------------------------------

Error Message:
Query (2, 14) The M parameter not defined in model or M parameter type is not valid.

----------------------------------------------------------------------------

 

 

 

 

 

 

 

2 Replies