Forum Discussion

Helper IV

5 years ago

M Query filter

Hello, I am using the following document to create an M Query Parameter but can't get it to work. In Query Editor, the source query (direct query, not import) runs fine with the custom sql using t...

Community Support

5 years ago

Hi, richard_wylde

The sample data I downloaded can't be opened. Can you share sample data and error images in onedrive for business? So we can help you soon.

Best Regards

Janey Guo

richard_wylde
Helper IV
5 years ago

Hi v-janeyg-msft

Perhaps the data's not available because it is Direct Query - I've re-attcahed the PBIX here and here is a screenshot , the lower slicer is not working

thank you
- v-janeyg-msft
  Community Support
  5 years ago
  Hi, richard_wylde
  
  I'm sorry that I can't open your file and can't see any data because you use DQ, so I can't visually see the problem.
  You can try to modify your formula:
  
  where status =Text.Insert( """&&""",2,status)
  
  Best Regards
  Janey Guo
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - richard_wylde
    Helper IV
    5 years ago
    Thanks v-janeyg-msft - no luck unfortunately, I changed it to :-
    
    where b.status =Text.Insert( """&P_STATUS&""",1,b.status)
    
    but it says the default value of the parameter does not exist :-
    
    DataSource.Error: PostgreSQL: 42703: column "JASON1" does not exist