Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
----------------------------------------------------------------------------
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
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |