Forum Discussion
RedDragon
Helper I
5 years agoShow 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
- Icey
Community Support
Hi RedDragon ,
Try this: Use Slicers for Query Parameters in PowerBI.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
- RedDragon
Helper 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.