Forum Discussion
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
- v-luwang-msftCommunity Support
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
- v-luwang-msftCommunity Support
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