change parameter values directly from the report in PowerBI Online

[powerbi2]

We have powerBI report deployed online and the report has start date and end date as parameters and it calls a stored procedure with these parameters. 

If the user wants to change the parameters, they have to go to Datasets - settings - update parameters and refresh dataset.

This is not very intuitive and wondering if there is any way to let the users change parameter value directly from the report itself.

any ideas on  how this can done?  Thank you.

We have a similar one in tableau and in there Start and End date parameter show up in the report, so, we can enter values directly in the report.

[zoloturu]

Hi @powerbi2,

There are no such capability in easy way. Only if you integrate Power Apps into the Power BI Report. And they Power Apps visual will send parameters to the database via Microsoft Flow where they will be stored. And they you can run your stored procedure.

Details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/embed-powerapps-powerbi

https://docs.microsoft.com/en-us/flow/guided-learning/

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!