Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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!
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |