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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
6 years ago

Hi Anonymous ,

Normally, we could edit parameter setting in power bi service.

Please refer to this document.

Best  Regards,

Cherry

pthapa's avatar
pthapa
Post Patron
2 years ago

Is there a way or workaround that report users will enter the parameter value in the report visual instead of doing it in the settings, sementic model?

Allowing users to access sementic model is not the best approach.

Thanks,

Pthapa