Forum Discussion

RedDragon's avatar
RedDragon
Icon for Helper I rankHelper I
5 years ago

Show visuals with data from stored proc parameter pass through

Hi there

 

i have a SQL stored proc with one parameter called AsOfDate. I need to allow users to select a date on the dashboard and the stored proc needs to run with the data selected. Is there a way to do this?

 

i tried https://cebrusa.com/2019/08/27/run-stored-procedures-using-parameters-in-powerbi/ but that didnt help. Perhaps I could build futher on this to allow the paramter to be selected by the user?

2 Replies

    • RedDragon's avatar
      RedDragon
      Icon for Helper I rankHelper I

      it says that This is a solution that will only work in Power BI Desktop and not in the service.

       

      I need the solution to run on desktop and service.