Forum Discussion
Executing SQL Server stored procedures with parameters from Power BI report
We have a Power BI report on which we need to execute a stored procedure from. The stored procedure needs to take a dynamic parameter as well. Ideally we would like the user to be able to select the ...
Assuming you're connecting to the stored procedure via Direct Query?
There is a Power Bi preview feature which I think does what you need:
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
yes direct query, thanks will check out that link