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
JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hi Anonymous,

 

the way you imagine it will not work, because the slicer is 'active' after PowerQuery is executed and "you can't get back".

 

What you can do is when the user opens the report he has to enter a year parameter.

 

To do this, I'd like to refer you to this article. This is about entering a username and receiving the data but the principle is basically the same.

 

I don't see any more elegant way to accomplish this.

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

  • 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.

    • JosefPrakljacic's avatar
      JosefPrakljacic
      Solution Sage
      6 years ago

      Hey does this meet your requirement?

    • 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

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      6 years ago

      Hi Anonymous ,

      Have you solved the problem?

      If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

      If you still need help, free to ask.

      Best  Regards,

      Cherry