Forum Discussion

Pbik88's avatar
Pbik88
New Member
3 years ago
Solved

Dynamic Parameter not working using M query and slicer

Hi,   I have watched several videos on creating a dynamic M query using Direct Query and a parameter and then updating the parameter through a slicer in the front end.   Although I followed all s...
Need Help
Tips and Tricks
  • Pbik88's avatar
    Pbik88
    3 years ago

    ***Solved***

     

    I updated my PBID to the latest version and it's working now!

     

    I think the older version let you create the dynamic M query using Oracle DB but did not work but the latest one does.

     

     thanks for all your help!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Pbik88 , Only additional thing I found in the document is this

If your parameter is of Date/Time data type, you will need to cast it within the M query as DateTime.Date(<YourDateParameter>)

 

 

I will try to check on my local env too.

Pbik88's avatar
Pbik88
New Member
3 years ago

***Solved***

 

I updated my PBID to the latest version and it's working now!

 

I think the older version let you create the dynamic M query using Oracle DB but did not work but the latest one does.

 

 thanks for all your help!