'Power BI : execute stored procedure chosen parameter by user via web portal
I want to execute a SQL Server stored procedure which takes 9 parameters and show results to user as a table view format.
My aim is user can select values of 9 parameters from Power BI web or can input values to boxes for 9 parameters, and when user hits apply button, the stored procedure is run and displays data as result.
The stored procedure calculates several columns values according to values of 9 parameters so report should be in direct query mode.
Is this possible? I've look around and there are several solutions but not what I want.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|