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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey vijeth_sankethi

 

If you are using DirectQuery, you can achieve this by running SQL code in an R visual. It's quite the workaround but works great. Check out my video here if you're interested:

 

https://www.youtube.com/watch?v=3QiTBXfxzHA

 

Hope this helps,

Parker

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vijeth_sankethi

     

    Yep! Any selection you make on any slicer or visual will re-run the r script and execute the stored procedure. I just used the drill-down player to make it automated

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