The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
61 |
User | Count |
---|---|
276 | |
129 | |
124 | |
100 | |
89 |