Forum Discussion
Dynamic m query parameter
Hi,
I have created a dataset with a direct query which uses a datetime parameter to filter the recrods. All visuals are working initially.
I then created a new table and bound the column to the parameter (after enabling dynamic query preview feature). When i choose a value from slicer/filter of the newly created column it shows can't display visual and shows the message: The M parameter 'Parameter name' not defined in model or M parametertype is not valid. I am able to modify the parameter from edit parameters on desktop and everything works as expected.
Only problem is with the dynamic parameter linking. I have done some basic checks, datatype is of supported datetime and the parameter is linked and working on desktop.
- Anonymous5 years ago
Hi ramanathans ,
Could share your pbix file ?
You could take a look at the official document for reference ,try to follow it step by step and pay attention to the Note part
Best Regards,
Eyelyn Qin
5 Replies
- lbendlinSuper User
not clear where you see the issue - is this in the workspace, or in the app? What license do you have, and what SKU?
- AnonymousNot applicable
Hi ramanathans ,
Could share your pbix file ?
You could take a look at the official document for reference ,try to follow it step by step and pay attention to the Note part
Best Regards,
Eyelyn Qin - AnonymousNot applicable
How to fix it?
- AnonymousNot applicable
Hi ramanathans
I am facing the same issue, could you please explain how you could resolve it. Thank you.
- holaFrequent Visitor
did anyone find the solution? I am facing the same problem. My database version is Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 29 2021 13:52:20 Copyright (C) 2019 Microsoft Corporation
Do you think this is the problem of this error?
if yes then could anybody let me know any other alternative?