Forum Discussion
Query Parameter in Power BI Service
Hi mohammadNimer ,
If you are just looking to have the ability to search for a client when you have all of the data, that is quite easy in the visual in Power BI. You can just use a slicer for "Client" and the list will be available. This is "instant" in the Service (because your data is already refreshed and is ready for use AND/OR if you use Direct Query then it will be available as well).
Thanks for the answer.
But actually, I wanted do de filter before the load of the query. This way, I don't need to load all the data to filter for the client code.
I wanted just to parametrize my query with a input from the user.
Hey mohammadNimer ,
I understand now what you are wanting - and, no, you can't do that in PBI directly. The reasoning is that the tool has to get all of the data to know what data is available to filter - and, so, that defeats your purpose of trimming out data ahead of time.
I am thinking that if you created some sort of Power Automate that had an input and that passed the input to run the query then you might get what you want (that is totally theory, I do not know HOW to do that).
