Forum Discussion
rizwanmalik
2 years agoRegular Visitor
Input string parameter in Power BI
Hi all, I have a requirement to migrate a Tableau report to Power BI. In tableau, there is a text parameter that takes a string from end user and pass it on to a stored procedure that runs and bring...
rajendraongole1
2 years agoSuper User
Hi rizwanmalik -In Power BI, you can create a parameter that takes a string input from the end user and pass it to a stored procedure using a combination of Power Query and dynamic M code
Go to Home > Transform data to open the Power Query Editor.
In the Power Query Editor, go to Manage Parameters > New Parameter.
Name your parameter (e.g., UserInput), set the data type to Text, and set the default value if desired.
Click OK.
Ref:
Parameters - Power Query | Microsoft Learn
Power Query and Stored Procedures with Parameters | Reeves Smith's SQL & BI Blog (wordpress.com)
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!