Forum Discussion

ramanathans's avatar
ramanathans
Frequent Visitor
5 years ago
Solved

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. 

  • Anonymous's avatar
    Anonymous
    5 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

  • not clear where you see the issue - is this in the workspace, or in the app? What license do you have, and what SKU?

  • Anonymous's avatar
    Anonymous
    Not 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    How to fix it?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ramanathans 

    I am facing the same issue, could you please explain how you could resolve it. Thank you.

  • hola's avatar
    hola
    Frequent 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?