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!

Pbik88's avatar
Pbik88
New Member
3 years ago

Thanks amitchandak , yes I am using Direct Query, also confirmed that this feature supports Oracle DB.

 

Below are the steps I performed :

 

1. Created a report using Direct Query to connect to my Oracle DB using a simple select statement with no where condition.

2. Created a Paramater of type Date Time and added a default value

3. Using Advanced Editor modified the M query to use the date filter from this paramater

4. Created a slicer with a list of Date Time values I wanted to filter my data on

5. Linked the date time column in the slicer to the paramater using Bind to Paramater under Advanced properties

6. Tried selecting different values from the dropdown in the slicer 

 

However, my report was generating data for only the date time value I manually entered in my paramater.

 

I am not sure where I am wrong since I am not getting any errors , it's just that the report does not refresh after changing the input date time from the slicer.

 

I would understand if the correct value would not get passed from the slicer or there was no data available for the particular date, but then the report should atleast have been empty to suggest that instead of showing data for the initially set paramater value.