Changing a DirectQuery parameter from a button.

[F_Aguilo]

Hi, I wanted to know if it is possible to configure a button to change a DirectQuery parameter or to change the whole DirectQuery sentence when pressed. 

An example of what I'm trying to do is make a report that retrieves the data directly from MySQL, and gets the top 10 stores with highest sales and use them to create the report, then after the user press the button, it shows the next 10 stores in the ranking skiping the first 10, and so on. 

I want to know if it's even possible to do this or if power BI it's not what I need, thanks in advance.

[amitchandak · Accepted solution]

@F_Aguilo , I think dynamic M parameters can help

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

https://www.youtube.com/watch?v=rFI6pc94WdM

https://www.youtube.com/watch?v=L-wqwzj0-Xo