Forum Discussion
Query Parameter in Power BI Service
Hello community, I have a project that i wanted to migrate from excel to PowerBI Service and get availiable within the app for some users. We have a query via ODBC on excel with the client code...
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).