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.

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