Forum Discussion

vijeth_sankethi's avatar
vijeth_sankethi
Frequent Visitor
8 years ago

Execute stored procedure with user parameters

Hi All,    I am still trying to learn the nuances of Power BI as I am from a SSRS background.    I am trying to achieve the following in Power BI.  The user should have an option to select a dat...
Need Help
vijeth_sankethi's avatar
vijeth_sankethi
Frequent Visitor
8 years ago

Hi Anonymous,

 

This is the closest to the solution I have been searching for. Thank you..

 

But Instead of the Drill down player, Can we use something like a Date picker / Text box which is used by the user and based on his selection, that date value would be passed to a Stored Procedure and results are shown in a table? 

 

Apologies if the question is basic but I can't seem to get it working. 

 

Thanks,

Vijeth

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi  vijeth_sankethi,

 

Have you solved your 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, please feel free to ask.

 

Best Regards,

Cherry

  • vijeth_sankethi's avatar
    vijeth_sankethi
    Frequent Visitor
    8 years ago

    Hi v-piga-msft, 

     

    Unfortunately, I was not able to get the solution in the way I wanted. I had tried Anonymous solution but it didn't work the way I expected. It is maybe because I am a newbie in Power BI and couldn't get it to work. I can give more details if you need.  So I didn't mark it as a solution. 

     

    Thanks, 

    Vijeth

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi vijeth_sankethi ,

       

      I am wondering if there has already been a solution for this? I am also facing the same problem as I am moving all my SSRS reports to Power BI. I am also a newbie at PowerBI so a solution would be greatly appreciated. Thanks!

      • vijeth_sankethi's avatar
        vijeth_sankethi
        Frequent Visitor
        7 years ago

        Hi Anonymous ,

         

        Unfortunately, I wasn't able to get that working in the way I expected. So Instead, I executed the Stored Procedure for all possible Input values and stored the results in a table. This table was then used to populate the Power BI report. Sorry for not being to help you. 

         

        P.S. I wrote another job which calls the SP to populate the base table. This job runs daily and since my source is a Data warehouse which is populated daily, it worked out in the end. 

         

        Thanks,

        Vijeth