Soheil Bakhshi shows how we can take an input from Power Query and pass it to a stored porcedure:
This is the fourth one in the form of Quick Tips. Here is the scenario. One of my customers had a requirement to get data from a Stored Procedure from SQL Server. She required to pass the values from a Query Parameter back to SQL Server and get the results in Power BI.
The solution is somewhat easy.
If you’re familiar with SQL Server Reporting Services, the solution instantly makes sense.