Forum Discussion
M Database Query Text Parameter - Advanced Properties on Slicer table does not show Bind options
I've enabled the "Field parameters" preview feature in settings. I've followed the instructions to modify an M-based Power Query of a Table to work with a Parameter - which I can set by hand and work...
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.
If it makes a material difference, the data source is a Synapse SQL table from a Microsoft Data Lake fed from Dynamics 365 Finance.