Forum Discussion
User input parameters for direct query
I'm flummoxed but after searching for a number of days for this, I'm becoming convinced this is an extremely simple capability that's apparently been ignored by the Power BI platform possibly. Al...
Thanks, yes I'll head over there and make that suggestion.
In regard to the filter pane. It seems to me filtration is done after data retrieval (not pushed down or "folded" into query execution as a condition on the data source). I don't think anything done in that filters panel seems to be pushed down to the data source as conditions which is contrary to my entire intent. At least if I go to "view native query" it doesn't show any of the filter criteria. I think all that happens after retrieval.
See my earlier link for Dynamic M Query parameters - but that requires your data source to be in Direct Query mode.