slicer paramter error m query

[project101]

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.

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

[v-luwang-msft]

Hi @project101 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @project101 ,

I'd like to suggest you try query parameter . For further information, you may refer to the following blogs.

 Deep Dive into Query Parameters and Power BI Templates 

Power BI Desktop Query Parameters 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien