Query Parameter in Power BI Service

[mohammadNimer]

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, as show below:

In this excel we can change the cell that represents client code, and this will update our query only for this client (because is very slow to get all clients and then filter for one).

My problem now is: how can i do this same behaviour on power BI Service. I know i can create a parameter and set a value by default, but this will not change if we publish on the app.powerbi, and i wanted put some drop list or field that the user input to the parameter.

Any sugestions?  

[collinq]

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).

[mohammadNimer]

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.

[collinq]

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).