Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
powerbi2
New Member

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
zoloturu
Memorable Member
Memorable Member

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors