Forum Discussion
Direct query dynamic column selection
I am familliar with passing user entered values to a query in Direct query/live connection using dynamic M query parameters as discussed here https://learn.microsoft.com/en-us/power-bi/connect-data/...
Hi kahn_ohara ,
Based on the knowledge, it is impossible to create a parameter to filter the columns.
1.Create the query and use Table.ColumnNames to get the names.
2.Drag the Invoked Function into the slicer. When select the column, can not filter the table.
You can view the following documents to learn more about information.
Parameters - Power Query | Microsoft Learn
You can raise a new idea and add the comments there to make this feature coming sooner.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.