Query parameter on the dashboard

[pollyog]

Hello guys!

Is there a possible way to creat a enter box where the user could insert a text (ex.: user ID) and this value be used in a MySQL (already configured) query as a filter?

Ex.: The user enter de user ID 123 on the dashboard and press "Update". Then, this 123 value will be used in the where condition of the query.

Thanks!!

[DataInsights]

@pollyog,

You could try Dynamic M Query Parameters:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters