Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I am unable to filter data using slicer/column which is binded with an m-query parameter (type: text). This parameter is used in making the Oracle SQL query dynamic. The table using this parameter is in Direct Query mode.
Able to type in the parameter values manually and filter the data, but unable to use the dynamic filtering functionality after binding the parameter with an imported column. Also tried with disabling security feature for native database queries, but no luck.
One thing I observed is that, after I have binded the column with the parameter I'm starting to see this icon indicaton for that column.
icon:
Not sure why it is showing that way. Searched for articles/blog-posts/videos but found nothing on this issue.
Help from anyone is greatly appreciated.
Thanks in Advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For the icon shown in Power BI Desktop, it is by design which is not related to this issue.
About dynamic M paremters in Power Query, suggest that you can follow this blog which introduces it in details:
Dynamic M query parameters in Power BI Desktop
Besides, here are some limitations in the document about it that you need to consider:
Considerations and limitations
Best Regards,
Community Support Team _ Yingjie Li