Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pass parameter to SQL Stored Procedure query from Slicer

Hi all, As the title, we are now facing a problem with the data source. We have a stored procedure which required a parameter is YEAR, because we need to filter the data by Year before showing on th...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much JosefPrakljacic,

It's really helped me out when I need to change the data from DataSource.

But it just requests the Parameter when Open the PowerBI Template file with Power BI Desktop, can we apply it with the Power BI Web? 

Hope to hear from you soon.

pthapa's avatar
pthapa
Post Patron
2 years ago

Hello,

As far as I know about passing parameter values on the web(service); you can only do it in the dataset settings. You will have to give user access to the dataset inorder for the user to be able to enter the parameter value. I don't belive so far there is a way to have user enter the parameter value in the report and get the data, I wish power bi will update such requirements in the future updates. We really need that option enabled.

In the sementic model, the user need to go to the schedule refresh icon, go to parameter section and you will have option to enter the parameter value there, then apply. After that, they need to manual refresh the dataset inorder for the the parameter to take effect. Hope this information helps.

 

Thanks,

Pthapa