Forum Discussion
M Database Query Text Parameter - Advanced Properties on Slicer table does not show Bind options
Hi Anonymous ,
If you want to use dynamic M query parameters, then make sure that the data source you are referencing the parameters from (i.e. table InvoiceFocus) is using Direct Query mode.
For more information, please refer to: Dynamic M query parameters in Power BI Desktop
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If you want to use dynamic M query parameters, then make sure that the data source you are referencing the parameters from (i.e. table InvoiceFocus) is using Direct Query mode.
For more information, please refer to: Dynamic M query parameters in Power BI Desktop
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I was Importing the data rather than leaving the connection open in DirectQuery mode. Sum result is i've accepted defeat in my quest to use different length part number prefixes used as slicers in a report; I can't issue a query on slicers "HEXHEX21", "SASSAS20" and "ESRIESRI20" on an imported data source. So i've given folks 3 separate reports, one prefix each.