cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbi2 Frequent Visitor
Frequent Visitor

change parameter values directly from the report in PowerBI Online

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.

1 REPLY 1
Highlighted
zoloturu
Advisor

Re: change parameter values directly from the report in PowerBI Online

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!

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,142)