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